NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR13FA115Accident · 2 fatalField investigationFinal reportBeech E90 · Casa Grande, AZThe pilot’s loss of control of the airplane after pitching it excessively nose up during a go-around, which resulted in a subsequent aerodynamic stall/spin.NTSB WPR13CA117Accident · No injuriesData collectionFinal reportCessna 170B · Sunburst, MTThe pilot's failure to compensate for the strong, gusting wind conditions, which resulted in a loss of airplane control during takeoff.NTSB ERA13LA127Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Merritt Island, FLA total loss of engine power due to fuel starvation, which resulted from an overstress failure of a fitting on the fuel supply line and led to an autorotation and hard landing.NTSB CEN13LA155Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Tulsa, OKThe line technician’s failure to remove the refueling mat from the helicopter fuselage following servicing, which resulted in the mat striking the tail rotor in flight, and the pilot’s inadequate preflight inspection.NTSB DCA13WA059Incident · No injuriesForeign investigationBoeing 737 · Sao Luis, BrazilOn 5 February 2013, at about 0204 UTC time, a B737-73V, registration # PR-VBI, operated by VRG Linhas Aeras GOL, executed a go-around because of an unstabilized approach during their initial approach into Imperatriz-Prefeito Renato Moreira Airport (SBIZ),…NTSB ANC13LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Kalskag, AKThe pilot’s decision to take off into deteriorating weather conditions, which resulted in a loss of visual reference and the subsequent controlled flight into terrain. Contributing to the severity of the rear seat passenger’s injuries was the incorrect…NTSB ERA13LA126Accident · No injuriesLimited investigationFinal reportMccowan Steve A Shttd · Montrose, GAA total loss of engine power during cruise flight due to the separation of the No. 2 piston connecting rod.NTSB WPR13LA111Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Boise, IDThe pilot's failure to maintain a proper glidepath and stabilized approach, which resulted in the airplane touching down short of the runway.NTSB ERA13WA128Accident · 5 fatalForeign investigationBeech C90 · Candido Mota, BrazilOn February 3, 2013, about 2230 coordinated universal time, a Beech C90A, Brazilian registration PP-AVG, was destroyed when it impacted terrain near Cândido Mota, Brazil. The pilot and four passengers were fatally injured. The flight originated from Regional…NTSB DCA13WA054Incident · No injuriesForeign investigationBoeing 737 · Seoul, South KoreaThe Aviation and Railway Investigation Board of Korea has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on February 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB investigation under the…NTSB WPR13LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilcox, AZThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.NTSB WPR13LA112Accident · No injuriesLimited investigationFinal reportCessna 305A · Camarillo, CAA tailwheel vibration upon touchdown and the subsequent loss of directional control for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR13LA108Accident · No injuriesLimited investigationFinal reportCessna 175B · Wellsville, UTA loss of engine power during cruise flight due to carburetor ice.NTSB ERA13RA125Accident · 3 fatalForeign investigationRobinson R44 · Asuncion, ParaguayOn February 2, 2013, about 2115 local time (February 3, 2013, 0015 coordinated universal time), a Robinson R44, Paraguayan registration ZP-HAH, operated by Helitactica S.A., was destroyed when it impacted sparsely populated terrain about 27 nautical miles…NTSB CEN13CA187Accident · No injuriesData collectionFinal reportChampion 7GCAA · Oshkosh, WIFatigue cracking and failure of the left wheel strut mount resulting in collapse of the left main landing gear during taxi.NTSB WPR13LA109Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bountiful, UTA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR13CA114Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Worland, WYThe pilot's failure to maintain directional control during landing.NTSB CEN13LA149Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · College Station, TXThe flight instructor’s and commercial pilot’s failure to see and avoid the other airplane, which resulted in a collision during cruise flight. Contributing to the accident was the failure of the flight instructor to activate the transponder before departure,…NTSB CEN13LA148Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta II · Gillett, TXA loss of tail rotor effectiveness while manuevering at low altitude.NTSB CEN13CA151Accident · No injuriesData collectionFinal reportCessna 172 · Murphysboro, ILThe pilot’s failure to maintain control of the airplane during the takeoff roll.NTSB CEN13LA152Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Victoria, TXThe mechanical failure of the engine power section, which resulted in a loss of engine power.NTSB WPR13CA107Accident · No injuriesData collectionFinal reportRobinson R22 · Kona, HIThe pilot’s failure to maintain adequate main rotor rpm during a practice autorotation and the flight instructor's delayed action, which resulted in a hard landing.NTSB ENG13WA014Incident · No injuriesForeign investigationMcdonnell Douglas MD-82 · Copenhagen, Denmark, DenmarkOn January 30, 2013 an MD-82, registration number SE-DIK, sustained a serious engine failure during the takeoff roll. The engine has been removed from the airplane and will undergo a teardown examination. The Danish Accident Investigation Board is…NTSB WPR13WA156Accident · No injuriesForeign investigationHawker 900XP · Halim, Indonesia, IndonesiaOn January 29, 2013, at an unknown time, a Hawker 900XP, PK-JBH, experienced a left main landing gear collapse during the landing roll at Halim Airport, Indonesia. The airplane was operated by Jhonlin Air Transport under the pertinent civil regulations of…NTSB ERA13CA122Accident · Minor injuriesData collectionFinal reportAmirkhanian Shahram Charl Commander · Westminster, MDImpact with power lines due to the pilot’s obscured vision due to the low angle of the sun, which prevented the pilot from seeing the lines.NTSB DCA13WA050Accident · 21 fatalForeign investigationBombardier CL600 2B19 · Almaty, KazakhstanThe Accident Investigation Department of the Ministry of Transport and Communications of the Republic of Kazakhstan has notified the NTSB of an accident involving a Bombardier Challenger CRJ-200, registration UP-CJ006, which occurred on January 29, 2013. The…NTSB CEN13CA145Accident · No injuriesData collectionFinal reportHughes 369HS · London, OHThe pilot's failure to comply with established cold weather operating procedures, which resulted in a total loss of engine power. Contributing to the accident was the pilot's excessive aft cyclic input during the landing flare, which resulted in main rotor…NTSB CEN13LA147Accident · No injuriesLimited investigationFinal reportWebb Webb 2 · Gainsville, TXThe pilot’s failure to follow his test plan and abort the takeoff after inadvertently lifting off during a high speed taxi test. Contributing to the accident was the pilot’s lack of flight experience in the gyroplane.NTSB WPR13LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Atwater, CAThe student pilot's inadequate flight planning, which resulted in his getting lost and not being able to return to the airport before the fuel was exhausted and the engine lost power.NTSB ERA13LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Yonkers, NYA partial loss of engine power for reasons that could not be determined because examination of the engine and associated components did not reveal any mechanical malfunction or failure that would have precluded normal operation.NTSB ERA13LA119Accident · Serious injuriesLimited investigationFinal reportShoemaker James B KR-2 · Palmetto, FLThe total loss of engine power for undetermined reasons, which resulted in a forced landing.NTSB ERA13CA123Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Lancaster, PAThe pilot’s failure to maintain clearance from a parked vehicle while taxiing from landing.NTSB CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…NTSB ANC13WA025Accident · 1 fatalForeign investigationRobinson R44 · Fox Creek, Alberta, CanadaOn January 27, 2013, about 1500 Mountain standard time, a Robinson R-44 Raven II helicopter, Canadian registration C-FRSO, broke up in flight over a wooded area, approximately 21 nautical miles southwest of Fox Creek, Alberta, Canada. The pilot, the sole…NTSB ERA13LA118Accident · Minor injuriesLimited investigationFinal reportHiller-Tri-Plex Ind.Inc. UH-12B · Okeechobee, FLThe pilot's failure to monitor carburetor temperature and use carburetor heat in conditions conducive to serious carburetor icing, which resulted in partial loss of engine power.NTSB ERA13CA120Accident · No injuriesData collectionFinal reportMallory Christopher L RV-8 · Lake City, FLThe pilot’s failure to maintain directional control during the landing roll.NTSB DCA13CA043Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD11 · Denver, COthe flight crews failure to perform a takeoff performance data briefing following the final entries into the Flight Management System, which would have alerted them to the incorrect weight entry and resulting incorrect landing speeds. Contributing to the…NTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.NTSB CEN13FA143Accident · 4 fatalField investigationFinal reportRaytheon A36 · Richwood, LAThe pilot's failure to maintain control of the airplane during a missed approach in instrument meteorological conditions.NTSB CEN13CA142Accident · No injuriesData collectionFinal reportCessna 172S · Peoria, ILThe pilot’s inadvertent activation of the electric trim to the nose-down position, which resulted in the airplane being improperly configured for takeoff, and the flight instructor’s incorrect remedial action that allowed the airplane to porpoise.NTSB ERA13LA117Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Danbury, CTThe flight instructor’s inadequate preflight inspection in which he incorrectly estimated the airplane’s fuel quantity and his improper reliance on the fuel totalizer rather than the fuel quantity indicating and warning systems to determine the fuel on board,…NTSB DCA13WA042Incident · Minor injuriesForeign investigationBoeing 737 · Genoa, ItalyOn 23 January 2013, at about 0947 UTC time, a Boeing 737-800, registration EI-DCX, operated by RyanAir, declared an emergency and diverted into Genoa, Italy, after experiencing a pressurization problem on both systems. Two passengers sustained minor injuries…NTSB CEN13LA141Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · McKinney, TXCollapse of the landing gear for reasons that could not be determined because visual examination did not reveal any mechanical malfunction or failure that would have prevented the gear from locking in the extended position and postaccident damage precluded…NTSB WPR13LA099Accident · No injuriesLimited investigationFinal reportGoetz Helicycle · Mesa, AZThe pilot's failure to properly install and secure the wire connecting the electronic speed controller unit to the fuel controller actuator motor, which resulted in the wire’s disconnection in flight and the resultant partial loss of engine power.NTSB WPR13CA097Accident · No injuriesData collectionFinal reportCessna 140 · Tucson, AZThe pilot’s failure to maintain directional control during the landing roll and his excessive application of brakes, which resulted in a noseover.NTSB ERA13WA124Accident · 2 fatalForeign investigationBell 206B · Sao Paulo, BrazilOn January 21, 2013, at 1448 universal coordinated time, a Bell Helicopter 206B, Brazilian registration PR-JBN, sustained substantial damage when it impacted a dwelling. One crewmember and one passenger received fatal injuries and the two other passengers…NTSB WPR13LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Marysville, CAA total loss of engine power during initial climb due to fuel starvation, which resulted from maintenance personnel’s improper installation of the fuel selector handle. Contributing to the accident was an incorrectly modified fuel selector handle assembly.NTSB WPR13LA096Accident · Serious injuriesLimited investigationFinal reportQuicksilver Sport IIS · Camarillo, CAThe person on the ground’s failure to stay clear of a spinning propeller.NTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.NTSB WPR13FA095Accident · 2 fatalField investigationFinal reportCessna 140 · Boulder, UTThe pilot’s improper decision to maneuver at a low altitude and failure to adequately monitor the environment to maintain clearance from power lines.