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 NYC91FA205Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Wawayanda, NYThe pilot started a spin maneuver at too low an altitude to allow recovery. A factor in the accident was scattered clouds at 2500 feel MSL.NTSB LAX91LA351Accident · Minor injuriesLimited investigationFinal reportTexas Helicopter M74L · Lodi, CAThe inflight loss of control by the pilot for undetermined reasons.NTSB FTW91FA142Accident · 2 fatalField investigationFinal reportCessna 170A · Heath, TXThe inadvertent stall following an abrupt pull up while maneuvering at low altitude, and the pilot's impairment due to to alcohol and drug consumption.NTSB CHI91LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mount Pleasant, MIDirectional control was not maintained by the pilot. Factors related to the accident were a wet, grass runway and buildings adjacent the runway.NTSB CHI91DTG07Accident · No injuriesFinal reportAyres S2R · Drayton, NDMisjudged clearance by the pilot. A factor related to the accident is overconfidence in personal ability.NTSB CHI91DCJ05Accident · No injuriesFinal reportMcdonnell Douglas 269A · Harvard, NEThe pilot's failure to maintain adequate rotor RPM during aerial application maneuvers. A related factor was the pilot's inattention.NTSB ATL91LA156Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Camden, TNThe student pilot's delayed decision to abort the takeoff, resulting in his inability to stop the airplane in the remaining runway. Factors were the pilot's lack of total flying experience, and the high outside air temperature at the time of the accident.NTSB ATL91FA155Accident · No injuriesField investigationFinal reportPiper PA-46-310P · Cartersville, GAThe mechanic's improper replacement of the fuel line b-nut, and the inadequate inspection of the repair work by the quality assurance inspector.NTSB ANC91LA120Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKThe pilot-in-command's failure to mantain directional control of the airplane during the takeoff roll. Contributing to the accident was the crosswind.NTSB ANC91LA116Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Gulkana, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the unsuitable terrain selected by the pilot for landing which was rough, uneven and soft.NTSB NYC91LA204Accident · No injuriesLimited investigationFinal reportCessna 150J · Burgettstown, PAThe pilot-in-command's failure to maintain control of the airplane on the landing roll, resulting in an on ground collision with a tree. Factors related to the accident was the pilot's improper use of the brake system.NTSB NYC91LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Westerly, RIEngine failure for an undetermined reason. A factor was the pilot misjudging the clearance over a fence during an attempted forced landing.NTSB DEN91FA110Accident · 1 fatalField investigationFinal reportCessna 177 · Hygiene, COSuicide. A factor related to the accident was: the pilot's other psychological condition.NTSB CHI91LA255Accident · No injuriesLimited investigationFinal reportCessna 180 · Walker, MNDirectional control after landing was not maintained by the pilot. Factors related to the accident were a gusty crosswind and a downhill embankment (ditch).NTSB CHI91FA254Accident · 2 fatalField investigationFinal reportCessna 172M · Ottumwa, IAImproper IFR procedure by the pilot by not maintaining the proper minimum descent altitude (mda) until established on the ILS localizer and glidepath.NTSB BFO91LA074Accident · Minor injuriesLimited investigationFinal reportClifton Dixon Polliwagen · Chesterfield, VAThe partial loss of engine power caused by a misaligned rocker arm spring resulting in a reduction of exhaust valve opening.NTSB NYC91LA203Accident · No injuriesLimited investigationFinal reportCessna 150L · Moraine, OHThe failure of the pilot to maintain airspeed during a go-around, resulting in an inadvertent stall and in flight collision with terrain.NTSB LAX91LA347Accident · No injuriesLimited investigationFinal reportExperimental RV4 · Napa, CAThe installation of a non compatiable oil filter and system plumbing changes which induced the oil exhaustion event resulting in a forced landing and in flight collision with terrain.NTSB ATL91LA154Accident · No injuriesLimited investigationFinal reportPiper J3C · Middlesex, NCThe pilot's failure to maintain airspeed while maneuvering in a turn on initial climb out resulting in a stall.NTSB ATL91LA152Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Manning, SCThe pilot's failure to maintain directional control during the takeoff roll, and his failure to abort the takeoff in a timely manner once the airplane had departed the runway surface. A factor in the accident was the pilot's failure to utilize the entire…NTSB SEA91LA202Accident · 1 fatalLimited investigationFinal reportTaylor Air Command 532 Elite · Libby, MTLoss of control during takeoff due to the pilot's total lack of experience in the type of aircraft.NTSB NYC91FA199Accident · 3 fatalField investigationFinal reportBeech C23 · Pleasantville, NJA power loss due to a failed crankshaft, while operating over unsuitable terrain. Factors related to the accident were, the night conditions, the failure of maintenance personnel to detect the cracks using magnaflux inspections, the lack of adequate…NTSB MIA91LA193Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-698 · Atlantic Ocean (Atlantic Ocean)An inflight loss of power of both engines for undetermined reasons followed by a ditching in the Ocean.NTSB LAX91LA368Accident · No injuriesLimited investigationFinal reportCessna C-T210N · Modesto, CAThe pilot's failure to maintain the proper alignment over the runway. Factors which contributed to the accident were the pilot's inattentive handling of his aircraft, and the dark, nighttime condition.NTSB LAX91LA349Accident · No injuriesLimited investigationFinal reportLet L-13 · Byron, CAThe on ground collision with a hidden ditch not visible to the pilot during the landing roll out phase of a forced landing.NTSB LAX91LA348Accident · Minor injuriesLimited investigationFinal reportExperimental DSA-1 · Kingman, AZThe pilot-in-command's failure to maintain the proper altitude to ensure terrain clearance while conducting low level aerobatic maneuvers, resulting in an in flight collision with terrain.NTSB LAX91LA346Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 126E · Sutcliffe, NVThe pilot's inadvertent stall of the glider.NTSB LAX91LA345Accident · No injuriesLimited investigationFinal reportCessna 172N · Lake Elsinore, CAThe pilot's poor judgement for unwarranted low flying and poor visual lookout.NTSB DEN91LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Slaton, TXFailure of the engine's number three piston. A related factor was: collision with a ditch during the landing roll.NTSB CHI91LA251Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Elwood, INA premature lift-off which resulted in a mush/stall. A factor related to the accident was lack of total experience in type of operation.NTSB CHI91LA247Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MODirectional control was not maintained by the pilot. A factor related to the accident was lack of total experience in type of operation by the pilot.NTSB CHI91LA246Accident · 1 fatalLimited investigationFinal reportBeech 35A · Hager City, WIThe failure of the pilot to maintain airspeed above stalling speed while maneuvering.NTSB CHI91LA244Accident · No injuriesLimited investigationFinal reportAerostar Raven 557A · Indianola, IAFailure of the pilot to maintain altitude. Factors associated with the accident are complacency and diverted attention.NTSB ATL91LA153Accident · No injuriesLimited investigationFinal reportCessna T188C · Quitman, GAA total loss of engine power due to fuel starvation. The reason for the fuel starvation was not determined.NTSB ANC91LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Willow, AKWas the in-flight collision of the airplane with an object due to the pilot-in-command's lack of an adequate visual lookout. Contributing to the accident was the rough, uneven and narrow condition of the airstrip.NTSB SEA91LA200Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Murtaugh, IDThe improper preflight planning/decision by the pilot, resulting in his attempt to takeoff with the aircraft loaded over maximum certificated gross takeoff weight.NTSB NYC91LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Brookville, OHThe pilot's improper use of the flight controls resulting in loss of directional control and an inadvertent stall.NTSB NYC91LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Atlantic City, NJThe failure of the pilot of N6877M to insure the runway was clear prior to pulling onto the runway.NTSB NYC91DNC04Accident · Minor injuriesFinal reportLaurent A. Cloutier BD-5B · Gilford, NHEngine failure due to a faulty oil pressure relief valve resulting in an emergency landing on unsuitable terrain.NTSB LAX91LA343Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Byron, CAThe pilot's failure to refuel the airplane and his misjudging the distance to the runway.NTSB LAX91FA342Accident · 3 fatalField investigationFinal reportPiper PA 28-180 · Reno, NVFailure of the pilot to maintain proper airspeed by employing an excessive angle of attack during the takeoff climb during a go-around resulting in an aerodynamic stall and subsequent inflight loss of control. Contributing to the accident was the pilot's poor…NTSB FTW91LA140Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Laredo, TXThe improper installation of the oil filter adaptor 'o' ring (seal) by other maintenance personnel who distorted it. A factor was the rough, uneven terrain.NTSB DEN91LA109Accident · No injuriesLimited investigationFinal reportBeech V35 · Byers, COThe pilot's selection of an unsuitable landing site. Factors were: weather conditions and the ditch.NTSB DEN91LA107Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Tulsa, OKThe engine ailure for undetermined reasons. Factors were the light condition and the lack of suitable terrain.NTSB CHI91LA250Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Loman, MNFuel exhaustion due to fuel consumption calculations misjudged by the pilot.NTSB CHI91LA248Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Joliet, ILA proper climb rate was not attained which resulted in a mush/stall by the pilot. Factors related to the accident were performance data mis-judged due to lack of familiarity with the aircraft, and over confidence in aircraft's ability.NTSB CHI91LA245Accident · Serious injuriesLimited investigationFinal reportHiller 1345 · Michigan City, INFuel exhaustion due the pilot's delay in refueling. Factors related to the accident were pressure induced by others (passenger), and the absence of suitable terrain.NTSB ATL91FA150Accident · Serious injuriesField investigationFinal reportCessna 150J · Jonesboro, GAThe pilot's improper in-flight decision when he landed downwind, and beyond the proper touchdown point. Additionally, he failed to attain a safe climb speed, which resulted in a stall/spin. A factor was the high density altitude.NTSB SEA91LA199Accident · No injuriesLimited investigationFinal reportCessna C-152 · W. Yellowstone, MTThe failure by the pilot to calculate aircraft fuel comsumption and the pilot's poor inflight planning. Factors relating to the accident were the inadequate preflight planning by the pilot, his lack of qualification and experience, and his disorientation…NTSB SEA91LA198Accident · Serious injuriesLimited investigationFinal reportChance Vought F4U-4 · Chiloquin, ORThe loss of power due to engine failure, for undetermined reasons.