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 ERA11CA192Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot's failure to maintain directional control during the landing rollout.NTSB ANC11CA016Accident · No injuriesData collectionFinal reportCessna 140 · Anchorage, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop.NTSB ERA11WA189Accident · 1 fatalForeign investigationCessna 182 · Calamar, ColombiaOn March 14, 2011, about 0815 universal coordinated time, a Cessna, 182N, Colombian registration, HK1084, operated by Transportes Aereos del Ariari, crashed while returning to Aerodromo Jorge E. Gonzalez- San Jose Guaviare (SKSJ), Calamar, Colombia, shortly…NTSB ERA11LA191Accident · No injuriesLimited investigationFinal reportCessna 414 · New York, NYThe improper rigging of the right main landing gear, which resulted in ovestress fractures of a bolt and aft lug on the trunnion assembly.NTSB CEN11RA295Accident · No injuriesForeign investigationEclipse EA500 · Saanen, SwitzerlandOn March 14, 2011, at 1205 UTC, an Eclipse Aircraft Corporation, EA500, U.S. Registration N177EA, collided with a parked vehicle during landing at Saanen Aerodrome, Bern, Switzerland. The pilot and four passengers were not injured. The airplane was…NTSB CEN11CA225Accident · No injuriesData collectionFinal reportAms-Flight D.O.O. DG-500 Elan Orion · Boulder, COThe in flight loss of lift while landing, resulting in a collision with a fence.NTSB WPR11FA163Accident · Serious injuriesField investigationFinal reportSikorsky S-58ET · El Segundo, CAA partial loss of engine power and the failure of the external hook to release the load for undetermined reasons.NTSB DCA11WA104Incident · No injuriesForeign investigationBoeing 737 · Toronto, CanadaOn March 13, 2011, at 0657 eastern daylight time, a Boeing 737-8Q8 aircraft, registration C-FTAH, experienced stall stickshaker and overspeed clacker warnings upon takeoff from Toronto/Lester B. Pearson International Airport (YYZ), Ontario, Canada. The crew…NTSB ERA11CA188Accident · No injuriesData collectionFinal reportCessna 182T · Waynesburg, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB ERA11CA187Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Oxford, CTThe student pilot's inadequate landing flare and the certified flight instructor's inadequate remedial action, resulting in a hard landing.NTSB DCA11WA068Incident · No injuriesForeign investigationBombardier BD-100-1A10 · Iqaluit, CanadaOn March 12, 2011, a Bombardier BD100, registration N818RC, operated by Tri Marine Logistics, departed the runway to the right while landing on runway 35 at Iqaluit Airport (CYFB), Iqaluit, Nunavut, Canada. The airplane stopped about 100 feet from the edge of…NTSB CEN11FA228Accident · Serious injuriesField investigationFinal reportWaco UPF-7 · Brownsville, TXThe loss of engine power for undetermined reasons.NTSB CEN11CA224Accident · Minor injuriesData collectionFinal reportAyres S2R-T34 · Swan Lake, ARAn in-flight collision with power lines following an encounter with a wind gust.NTSB WPR11LA161Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta II · North Las Vegas, NVThe partial loss of engine power for undetermined reasons. Contributing to the accident was the certified flight instructor's decision to continue the flight after the helicopter exhibited inadequate performance capabilities and an unresolved power production…NTSB WPR11LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Agoura Hills, CAThe loss of engine power during cruise flight for undetermined reasons.NTSB WPR11FA490Accident · 1 fatalField investigationFinal reportRadford RV-6 · Grand Canyon, AZThe pilot's intentional flight into terrain.NTSB WPR11FA159Accident · No injuriesField investigationFinal reportFairchild SA227-AC · Seattle, WAThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.NTSB WPR11CA157Accident · No injuriesData collectionFinal reportAeronca 7EC · Big Bear City, CAThe pilot's improper maintenance, which resulted in a wheel separating from the airplane during takeoff, and the airplane's subsequent nose over during the landing rollout.NTSB OPS11IA410Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAThe air traffic controllers’ failure to adhere to required radar identification procedures, which resulted in loss of separation between the departing Boeing 757 and three other airplanes. Contributing to the incident was the pilots’ inadequate preflight…NTSB ERA11FA185Accident · 1 fatalField investigationFinal reportCessna 310R · Smyrna, TNThe pilot's improper response to a known autopilot pitch divergence anomaly. Contributing to the accident was the pilot's decision to perform a test flight on a system for which he lacked a complete working knowledge.NTSB ERA11CA186Accident · Minor injuriesData collectionFinal reportCessna 182P · Kissimmee, FLThe pilot's failure to maintain directional control during the landing flare.NTSB CEN11FA227Accident · No injuriesField investigationFinal reportLancair LC41-550FG · Carbondale, ILThe fatigue fracture and subsequent failure of the No. 2 cylinder exhaust valve during cruise flight, which resulted in a total loss of engine power.NTSB WPR11FA158Accident · No injuriesField investigationFinal reportCessna 208B · Bakersfield, CAThe malfunction of a master brake cylinder, which resulted in a loss of braking action and subsequent loss of directional control and collision with three vehicles during taxi. Contributing to the accident was the inappropriate design and manufacture of the…NTSB WPR11CA162Accident · No injuriesData collectionFinal reportCessna 180 · Pine, AZThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with terrain.NTSB ERA11IA184Incident · No injuriesIncident investigationFinal reportCessna 560XL · Haynesville, VAThe manufacturer's inadequate design fix for previously known tailcone stinger water ingestion and retention.NTSB CEN11WA476Accident · No injuriesForeign investigationAerospatiale SA-341G · Cumbria, United KingdomOn March 9, 2010, about 0055 universal time (UTC), a United Kingdom registered Aerospatiale SA-341G helicopter, HA-LFB, operated by TBC, sustained substantial damage when it impacted terrain near Honister Pass, Cumbria, United Kingdom. The pilot was fatally…NTSB CEN11LA226Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Bulverde, TXThe in-flight separation of the fuel cap, which impacted the helicopter’s tail rotor and resulted in the loss of tail rotor thrust. Contributing to the accident was the inadequate preflight inspection by both pilots, who did not ensure that the fuel cap was…NTSB WPR11FA156Accident · 2 fatalField investigationFinal reportDouglas AD-4N · Twin Falls, IDThe non-instrument-rated pilot’s encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA11FA183Accident · 2 fatalField investigationFinal reportDehavilland DHC-6-100 · Hampton, GAThe pilot did not maintain airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB ERA11CA193Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Pittstown, NJThe student pilot's inadequate flare and the certified flight instructor's inadequate remedial action, which resulted in a hard landing.NTSB CEN11WA691Accident · No injuriesForeign investigationPiper PA46-500TP · Lausanne, SwitzerlandOn March 8, 2011, at 1430 coordinated universal time, a Piper PA 46-500TP, N747AW, was substantially damaged while landing at the Lausanne-La Blécherette Airport (LSGL), Lausanne, Switzerland. Visual meteorological conditions prevailed at the time of the…NTSB CEN11GA218Accident · Minor injuriesFinal reportHughes 369D · Meeker, COMain rotor contact with the tail boom resulting in tail boom separation.NTSB WPR11FA155Accident · 1 fatalField investigationFinal reportMuse KR2 · Newberry Springs, CAThe airplane’s encounter with severe turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB ERA11FA182Accident · 1 fatalField investigationFinal reportDiamond DA-40 · Allagash, METhe pilot's inadvertent encounter with icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing was the pilots’ inadequate preflight weather planning.NTSB CEN11CA217Accident · Minor injuriesData collectionFinal reportPiper PA-22-108 · Lockhart, TXThe pilot's failure to maintain clearance from trees.NTSB CEN11CA216Accident · No injuriesData collectionFinal reportCessna A185F · Belle Chase, LAThe pilot's failure to ensure that the landing gear was retracted for the water landing.NTSB WPR11LA154Accident · No injuriesLimited investigationFinal reportCessna 210 · Pahrump, NVThe pilot's failure to extend the landing gear prior to touchdown and his improper decision to abort a gear-up landing following a propeller strike.NTSB ERA11WA220Incident · No injuriesForeign investigationBeech B200 · Vichada, ColombiaOn March 6, 2011, about 2140 Universal Coordinated Time (UTC), a Beech BE-200, Columbian registration HK-4108, operated by Servicio Aereo de Capurgana (SEARCA S.A.), was substantially damaged during landing at Vichada, Columbia, following loss of engine…NTSB ERA11CA181Accident · Minor injuriesData collectionFinal reportCessna 172K · Ocracoke, NCThe pilot’s inadequate flare and failure to regain control of the airplane while attempting to recover from bounced landing.NTSB ERA11CA180Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Weston, FLThe pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.NTSB ENG11RA030Incident · No injuriesForeign investigationBoeing 777 · Moscow, RussiaOn March 5, 2011, the crew of Emirates Airlines Flight 132, a B777-200ER (A6-EMH), powered by 2 Rolls Royce Trent 892 Turbofan Engines, reported a loud noise on takeoff from the No. 2 Engine area, while departing Moscow Domodedovo Airport (DME). The crew via…NTSB ANC11CA014Accident · No injuriesData collectionFinal reportCessna 172R · Montana Creek, AKThe pilot's failure to recognize that he was landing at the wrong airstrip on a snow-covered and unplowed runway, resulting in the airplane nosing over.NTSB WPR11FA153Accident · Serious injuriesField investigationFinal reportVolin Kitfox Classic IV · Myrtle Creek, ORThe pilot's encounter with a windshear/downdraft that exceeded the climb performance capabilities of the airplane.NTSB ERA11WA362Accident · Minor injuriesForeign investigationCessna 152 · Kingston, JamaicaOn March 4, 2011, about 1000 eastern standard time, a Cessna 152, Jamaican registration 6Y-JGA, was substantially damaged during a forced landing, following a total loss of engine power during initial climb from Norman Manley International Airport (MKJP),…NTSB ERA11LA179Accident · No injuriesLimited investigationFinal reportBeech C23 · Carrollton, GAThe mechanic's failure to re-connect a fuel line following an annual inspection. Contributing to the accident was the pilot's improper decision to depart with a known mechanical deficiency.NTSB DCA11WA034Accident · No injuriesForeign investigationMcdonnell Douglas MD82 · Bridgetown, BarbadosOn March 4, 2011, a Boeing MD-82 aircraft, 8P-ARB, operated by AirOne Venture Ltd., was conducting a high speed taxi on Runway 09 to perform some system checks on the airplane. As the airplane reached 80 knots, the airplane experienced an inadvertent…NTSB CEN11LA223Accident · No injuriesLimited investigationFinal reportLearjet 25 · Houston, TXThe flying pilot's failure to attain the proper touchdown point in low-visibility conditions, which resulted in a runway overrun. Contributing to the accident was mission pressure to land at that airport.NTSB CEN11LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Delphi, INThe pilot's loss of directional control, resulting in a runway excursion, and the subsequent separation of the left main landing gear for undetermined reasons.NTSB ERA11CA177Accident · No injuriesData collectionFinal reportQuist Kitfox · Indian Trail, NCThe pilot's failure to maintain directional control during an aborted landing, resulting in a runway excursion and collision with a vehicle.NTSB ERA11CA176Accident · No injuriesData collectionFinal reportCessna 172L · Fayetteville, GAThe pilot's decision to land with excessive speed in gusting, tailwind conditions, resulting in a runway overrun.