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 DFW08LA105Accident · 1 fatalLimited investigationFinal reportBlevens Gary Vortex · Berclair, TXLoss of control for undetermined reasons.NTSB DFW08CA112Accident · Minor injuriesData collectionFinal reportHaecker Spacewalker · Kingsbury, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW08CA107Accident · Minor injuriesData collectionFinal reportTecnam P2002 Sierra · La Porte, TXThe student pilot's improper recovery from the bounced landing and the instructor's delayed remedial action.NTSB DFW08CA102Accident · No injuriesData collectionFinal reportNorth American T-6G · Dallas, TXThe pilot's failure to maintain directional control while landing.NTSB DEN08FA078Accident · 2 fatalField investigationFinal reportCessna P206 · Mount Vernon, MOThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall/spin. Contributing factors in this accident were the entanglement of the parachute in the elevator control system, reducing the pilot's ability to regain control.NTSB MIA08FA091Accident · 1 fatalField investigationFinal reportAeroFab Lake LA-250 · Skaneateles, NYThe certified flight instructor's failure to maintain airspeed during a steep turn.NTSB LAX08TA116Accident · No injuriesFinal reportHughes TH-55 · Logan, UTThe pilot's inadequate compensation for the wind conditions and failure to maintain control of the helicopter while hovering. Contributing to the accident were the wind gusts and the pilot's lack of recent experience in helicopters.NTSB LAX08FA115Accident · 2 fatalField investigationFinal reportCessna 150J · Sonora, CAThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident were rising mountainous terrain and a high density altitude.NTSB LAX08CA120Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plant City, FLThe pilot's excessive taxi speed, which led to a loss of control.NTSB DEN08LA081Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Mosby, MOA loss of engine power for reasons undetermined, and the pilot's decision to discontinue the autorotation when he thought engine power had been restored. Contributing to the accident were the low altitude and excessive airspeed.NTSB CHI08IA113Incident · No injuriesIncident investigationFinal reportCessna 172P · Kelley's Island, OHThe pilot's failure to maintain aircraft control during landing. Contributing to the accident were the pilot's selection of the wrong runway and a tailwind.NTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.NTSB CHI08CA111Accident · No injuriesData collectionFinal reportVeldhuizen Highlander · Onida, SDThe separation of the right main wheel from the landing gear during takeoff for an undetermined reason.. Contributing to the accident were rough/uneven terrain and that directional control was not possible.NTSB CHI08CA110Accident · No injuriesData collectionFinal reportBeech 95-B55 · Lansing, MIThe pilot's inadvertent raising of the landing gear during rollout.NTSB MIA08LA090Accident · 1 fatalLimited investigationFinal reportEmory B. Wood Phantom X1 · Warrenton, VAA loss of engine power during initial climb for undetermined reasons.NTSB LAX08CA114Accident · No injuriesData collectionFinal reportMurphy Murphy Rebel · Grass Valley, CAThe pilot's failure to maintain directional control.NTSB DEN08LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Reserve, NMThe pilot's loss of aircraft control, resulting in an inadvertent stall. Contributing factors in this accident were the sudden windshift to a gusting tailwind, an uphill runway, high density altitude, the pilot's failure to use all available runwayt, and his…NTSB CHI08IA109Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Pontiac, MIThe inadvertent stalling of the rudder trim actuator motor during flight due to the pilot's unintentional exceedence of the motor's design limit for stalling while accelerating after completing a simulated engine-out maneuver.NTSB MIA08CA151Accident · No injuriesData collectionFinal reportCessna 182P · Salisbury, NCThe student pilot's improper flare during landing.NTSB LAX08FA109Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · San Dimas, CAA loss of engine power in the left engine due to fuel starvation as a result of the pilot's inadequate preflight inspection and the pilot's failure to abort the takeoff following the power loss.NTSB DEN08LA077Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Angleton, TXThe pilot's inadequate visual lookout and his failure to maintain clearance from the tranmission lines. A factor in this accident was the unmarked transmission wires.NTSB DEN08GA076Accident · 1 fatalFinal reportAir Tractor AT-602 · Fort Carson, COThe pilot's failure to maintain aircraft control following the jettison of the load during an aerial fire flighting mission, which resulted in an inadvertent stall and impact with terrain. Contributing to the accident were the improperly configured aircraft…NTSB NYC08LA162Accident · No injuriesLimited investigationFinal reportCessna 560XL · White Plains, NYAn uncommanded landing gear retraction after touchdown for undetermined reasons.NTSB LAX08LA108Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Columbia, CAThe flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…NTSB LAX08LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Holbrook, AZA total loss of engine power due to fuel starvation as a result of the pilot's fuel system mismanagement and incorrect positioning of the fuel selector valves.NTSB DCA08RA050Accident · 40 fatalClass 5 · ForeignMcDonnell Douglas DC-9-51 · Goma, Congo - KinshasaOn April 15, 2008, a Hewa Bora DC-9-51, registration 9Q-CHN, overran runway 18 and crashed into a residential area after aborting the takeoff. The aircraft was destroyed along with several residential buildings. Of the 86 passengers and 8 crewmembers onboard,…NTSB ANC08FA053Accident · 4 fatalField investigationFinal reportEurocopter AS 350 B2 · Chickaloon, AKAn in-flight overtorque of the engine-to-transmission driveshaft resulting in disconnection of the main transmission from the engine. The overtorque likely occurred due to an in-flight main rotor blade contact with snow-covered terrain, precluding significant…NTSB ANC08CA054Accident · No injuriesData collectionFinal reportCessna 172 · Tyndall AFB, FLThe pilot's misjudged flare and subsequent hard landing, and her inadequate recovery from a bounced landing.NTSB NYC08CA161Accident · Minor injuriesData collectionFinal reportCessna 152K · Okeechobee, FLThe loss of engine power during cruise flight due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB LAX08LA103Accident · Serious injuriesLimited investigationFinal reportArtic S-1B2 · Rock River, WYThe pilot's failure to maintain an adequate airspeed while maneuvering that led to an inadvertent stall. A contributing factor in the accident was the low altitude of the flight that reduced the time available for recovery from an upset.NTSB CHI08LA102Accident · Serious injuriesLimited investigationFinal reportBoeing E75N1 · Youngstown, OHThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall.NTSB MIA08LA089Accident · 1 fatalLimited investigationFinal reportDayon Lancair Legacy · Lakeland, FLThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's distraction with the canopy during takeoff.NTSB LAX08WA113Accident · Minor injuriesClass 5 · ForeignCessna 182 · San Quintin, MexicoOn April 13, 2008, about 0905 Pacific daylight time, a Cessna 182, N6278T, collided with a greenhouse during the initial climb out from a private airstrip in San Quintin, Mexico. The pilot and three passengers received minor injuries; the airplane was…NTSB LAX08CA112Accident · Serious injuriesData collectionFinal reportUltramagic N-250 · Buckeye, AZThe passenger's failure to hear and follow the pilot's instructions to get down in the bottom of the balloon basket before the high wind landing. A contributing factor was the high wind condition.NTSB LAX08CA102Accident · No injuriesData collectionFinal reportCessna 172S · Gualala, CAThe pilot's decision not to use all of the available runway, his premature rotation and failure to obtain and maintain an adequate airspeed to continue the takeoff that resulted in a stall/mush, an aborted takeoff, a runway overrun, and a collision with…NTSB DFW08CA098Accident · No injuriesData collectionFinal reportWeatherly 620B · Coleman, TXThe pilot's failure to maintain airplane control on the landing roll. A contributing factor was the variable wind.NTSB DEN08IA080Incident · No injuriesIncident investigationFinal reportHill Hatz CB-1 · Erie, COthe pilot's failure to maintain directional control during landing. A contributing factor was the gusty wind conditions.NTSB ANC08LA052Accident · Minor injuriesLimited investigationFinal reportPiper J5A · Big Lake, AKA loss of engine power during takeoff/initial climb for an undetermined reason.NTSB SEA08CA115Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Twisp, WAThe pilot's failure to maintain adequate clearance from a ground obstacle while taxiing.NTSB NYC08LA178Accident · No injuriesLimited investigationFinal reportEmbraer EMB-110P1 · Potsdam, NYThe pilot's failure to maintain directional control during landing.NTSB NYC08CA166Accident · No injuriesData collectionFinal reportWim J Huisman Velocity 173 Fixed · Ocala, FLThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the wind gusts.NTSB LAX08FA101Accident · Serious injuriesField investigationFinal reportCessna 310Q · Compton, CAThe loss of both engines' power during approach due to fuel exhaustion that resulted from the pilot's inadequate preflight inspection and failure to verify the quantity of fuel on board the airplane.NTSB LAX08CA106Accident · No injuriesData collectionFinal reportMaule M-5-235C · Monroe, WAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing rollout.NTSB LAX08CA100Accident · Minor injuriesData collectionFinal reportQuestair Venture · Salt Lake City, UTThe failure of the left side master brake cylinder that led to a loss of braking capability during landing rollout. A contributing factor was the presence of a ditch next to the runway's end.NTSB DEN08CA075Accident · No injuriesData collectionFinal reportCessna 182N · Amarillo, TXThe pilot's failure to maintain aircraft control during the landing. Contributing to the accident were the crosswind, gusty wind conditions and the pilot's inadequate compensation for the wind conditions.NTSB ANC08CA051Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Stevensville, MDThe pilot's misjudged speed/distance during landing.NTSB LAX08LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Concrete, WAA loss of engine power for undetermined reasons.NTSB LAX08LA098Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Kingman, AZA total loss of engine power during cruise flight due to an undetermined catastrophic internal engine failure.NTSB LAX08LA097Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Denio, NVThe pilot's inadvertent hard landing induced by a perceived loss of power and a main transmission anomaly while maneuvering at low altitude.NTSB LAX08CA110Accident · Serious injuriesData collectionFinal reportSnobird Charger · Toledo, WAThe pilot's improper use of the flight controls during takeoff.