NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 NYC07FA119Accident · 3 fatalField investigationFinal reportBeech BE-A55 · Dunkirk, NYThe pilot's failure to maintain aircraft control during a single-engine missed approach, after the failure of the airplane's left engine aft-top counterweight assembly. Contributing to the accident were instrument meteorological conditions due to clouds.NTSB NYC07CA120Accident · Serious injuriesData collectionFinal reportMaule MXT-7-180A · St Petersburg, FLThe pilot's failure to obtain the proper climb rate to clear an obstacle after aborting the landing. Factors in the accident were the pilot's failure to maintain directional control during landing, which prompted the aborted landing, and a wind gust.NTSB DFW07CA115Accident · No injuriesData collectionFinal reportCessna 172P · Harrah, OKThe pilot's failure to compensate for the existing wind conditons while landing. A factor was the crosswind.NTSB DFW07CA114Accident · Minor injuriesData collectionFinal reportAir Tractor AT-402A · Edmonson, TXThe pilot's failure to maintain clearance with the crops.NTSB SEA07CA130Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Merced, CAThe student pilot's inadvertent stall/mush during a simulated power loss after takeoff and the flight instructor's delayed remedial action, which resulted in a hard landing. A contributing factor was the flight instructor's lack of familiarity with the…NTSB MIA07CA097Accident · Minor injuriesData collectionFinal reportPiper J3-C-65 · Byron, GAThe pilots failure to maintain directional control of the airplane during takeoff.NTSB CHI07CA139Accident · No injuriesData collectionFinal reportCessna 150 · English, INThe pilot's inadequate preflight planning due to his decision to takeoff downwind, and his subsequent failure to maintain adequate clearance from the power line. Contributing factors to the accident were the power line and the trees.NTSB MIA07CA099Accident · No injuriesData collectionFinal reportCessna 172K · Emporia, VAThe failure of the student pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch.NTSB CHI07CA144Accident · No injuriesData collectionFinal reportGulfstream-Schweizer Gulfstream AM G-164B · Walnut Ridge, ARA non-mechanical loss of engine power during the takeoff roll due to fuel contamination. An additional cause was the pilot's inadequate preflight inspection. A factor in the accident was the soft ground.NTSB NYC07CA118Accident · Minor injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 · Franconia, NHThe pilot's failure to obtain the proper touchdown point. A factor in the accident was an encounter with an updraft while on approach.NTSB MIA07FA098Accident · 1 fatalField investigationFinal reportHughes 369A · Moulton, ALThe separation of a main rotor blade from its tension torsion bar for an undetermined reason.NTSB LAX07LA168Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Colusa, CAThe pilot's failure to maintain clearance from wires.NTSB LAX07LA167Accident · 1 fatalLimited investigationFinal reportSheely Rans S-12XL · Pinetop, AZthe pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with terrain.NTSB LAX07CA166Accident · No injuriesData collectionFinal reportPiper J3C-65 · Quincy, CAThe pilot's excessive use of the brakes, which resulted in a nose over.NTSB DFW07WA113Accident · 1 fatalForeign investigationCessna A188B · San Francisco, HondurasNTSB DFW07LA111Accident · Minor injuriesLimited investigationFinal reportBell 206B · Horseshoe Bay, TXThe pilot's loss of control as result of dynamic rollover while attempting to takeoff. Facrots were the landing skid becoming snagged and the soft terrain.NTSB DCA07WA043Incident · No injuriesForeign investigationBoeing 737-800 · London ControlNTSB SEA07FA119Accident · 5 fatalField investigationFinal reportCessna 182C · Marion, MTThe pilot’s failure to maintain aircraft control while maneuvering to reverse direction. Factors included the airplane exceeding its maximum gross takeoff weight, the improper preflight by the pilot by not securing an oil cap, the low altitude, and an…NTSB LAX07LA163Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Delta, UTthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall and collision with terrain.NTSB LAX07FA160Accident · 2 fatalField investigationFinal reportDiamond Aircraft Industries DA 40 · Lake Pleasant, AZThe pilot's failure to maintain sufficient altitude above the surface of water during an intentional buzzing maneuver. Contributing to the accident was the nighttime lighting environment.NTSB LAX07CA170Accident · No injuriesData collectionFinal reportCessna 172S · Carson City, NVThe loss of directional control for undetermined reasons.NTSB LAX07CA169Accident · No injuriesData collectionFinal reportCessna 172M · St. George, UTthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB LAX07CA165Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Moab, UTThe pilot's failure to obtain and maintain an adequate airspeed that resulted in a stall/mush. Also causal was the pilot's failure to abort the takeoff in a timely way. A factor in the accident was the high density altitude.NTSB LAX07CA164Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Red Lodge, MTThe pilot's inadequate compensation for gusty crosswind conditions and failure to maintain proper runway alignment that resulted in dragging a wing and ground looping. Also causal was the pilot's delayed decision to abort the landing.NTSB LAX07CA162Accident · No injuriesData collectionFinal reportCessna R172E · Dayton, NVThe pilot's misjudged flare, which resulted in a hard landing.NTSB LAX07CA161Accident · No injuriesData collectionFinal reportAeronca 11AC · Glendale, AZThe private pilot's unstabilized approach and failure to maintain directional control during the landing roll, which resulted in a ground loop. Also causal was the instructor's inadequate supervision and failure to take remedial action.NTSB DFW07WA110Accident · 1 fatalForeign investigationBell 47G · Ciudad Victoria, MexicoNTSB DEN07CA092Accident · No injuriesData collectionFinal reportCentrair 101C · Alamogordo, NMThe pilot's inability to control the glider after encountering the downdraft causing the glider to land short of the dirt strip. Factors contributing to the accident were the downdraft and the runway marker.NTSB DCA07WA041Incident · No injuriesForeign investigationBoeing 777-200ER · Tel Aviv, IsraelNTSB CHI07CA146Accident · No injuriesData collectionFinal reportEverett Zodiac 601XL · Lonoke, ARThe loss of engine power for undetermined reasons. An additional cause was the pilot's improper decision to enter the traffic pattern after intermittent losses of engine power, and his subsequent failure to remain within power off gliding distance of the…NTSB LAX07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Eugene, ORCollapse of the landing gear during landing for undetermined reasons.NTSB LAX07CA159Accident · No injuriesData collectionFinal reportCessna T210L · The Dalles, ORThe pilot's failure to extend the landing gear.NTSB LAX07CA157Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Mariposa, CAThe pilot's failure to maintain clearance from a vehicle while taxiing.NTSB DFW07LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · E. Cameron 219The pilot's failure to establish a climb and maintian directional control of the helicopter while departing the offshore platform.NTSB DFW07LA108Accident · Serious injuriesLimited investigationFinal reportCessna A188A · Clinton, OKSeparation of the exhaust stack and resulting vapor lock. A contributing factor was the none suitable terrain for the forced landing.NTSB CHI07FA140Accident · 3 fatalField investigationFinal reportCessna 172N · Sharonville, OHThe inadequate visual lookout of the pilots in both airplanes and their not maintaining clearance from each others airplane during climb.NTSB NYC07CA117Accident · No injuriesData collectionFinal reportCessna 172R · Hollywood, FLThe student pilot's inadequate recovery from a bounced landing which resulted in a loss of control and subsequent impact with a sign.NTSB MIA07CA096Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fairmont, WVThe pilot's failure to maintain directional control during landing.NTSB LAX07LA156Accident · 2 fatalLimited investigationFinal reportTeague Rans S-6ES Coyote II · Nyssa, ORLoss of aircraft control while maneuvering for undetermined reasons.NTSB LAX07LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, WAA loss of engine power during cruise due to carburetor icing, and the pilot's delay in using carburetor heat.NTSB LAX07CA154Accident · Minor injuriesData collectionFinal reportBurkhart Grob G103 Twin II · Minden, NVThe pilot's failure to maintain an adequate airspeed, which led to an inadvertent stall.NTSB DFW07LA116Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Morgan City, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA112Accident · No injuriesData collectionFinal reportCessna 180 · Austin, TXThe loss of engine power as result of carburetor icing. Contributing factors were the lack of suitable terrain for the forced landing and the weather conditions conducive to carburetor icing.NTSB CHI07CA153Accident · No injuriesData collectionFinal reportCessna 182S · Harvard, ILThe pilot's misjudged flare and improper recovery from a bounced landing, which caused the nose gear to collapse and subsequent damage to the propellor and underside of the airplane.NTSB CHI07CA142Accident · No injuriesData collectionFinal reportCanadian Car & Foundry Harvard MK IV · Peachtree City, GAThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and subsequent left main gear collapse.NTSB CHI07CA136Accident · No injuriesData collectionFinal reportCessna 182P · Traer, IAThe pilot's failure to maintain control of the airplane during landing on the grass airstrip. A contributing factor was the pilot's limited experience operating on grass runways. Additional factors were the runway cone struck during landing and the irrigation…NTSB ANC07CA033Accident · No injuriesData collectionFinal reportCessna 185 · Cantwell, AKThe pilot's inadequate compensation for wind conditions during takeoff initial climb, which resulted in a descent into high vegetation, and a nose over. Factors contributing to the accident were the pilot's inadequate weather evaluation and a downdraft.NTSB NYC07CA116Accident · No injuriesData collectionFinal reportCessna 172S · Asheville, NCThe pilot's improper landing flare which resulted in a hard landing. A factor in the accident was the visual illusion experienced by the pilot from landing on a long, wide runway.NTSB DFW07CA106Accident · Minor injuriesData collectionFinal reportCessna 152 · Houston, TXThe student pilot's failure to maintain directional control during landing. A contributing factor was the prevailing crosswind.NTSB CHI07WA141Incident · No injuriesForeign investigationDassault-Breguet Mystere Falcon 20-F5 · London, United Kingdom