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 CHI89LA177Accident · No injuriesLimited investigationFinal reportCessna 177B · Auburn, INFailure of the pilot to maintain directional control during the landing, which resulted in a ground swerve. Contributing factors were: the pilot's misjudgement of distance, speed, and altitude on final approach and high vegetation (tall grass & brush) beside…NTSB CHI89LA175Accident · Minor injuriesLimited investigationFinal reportCessna 182A · East Lansing, MIImproper corrective action on the part of the pilot to correct an excessive sink rate prior to landing touchdown.NTSB ATL89LA201Accident · No injuriesLimited investigationFinal reportBeech A-36 · Charleston, SCThe pilot's failure to maintain clearance from other parked aircraft while taxiing.NTSB MKC89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Clear Lake, MNThe pilot's improper decision in attempting to land with inadequate visual cues which precluded identification of a correct runway alignment. A suitable alternative airport was readily available.NTSB MIA89LA230Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · St Augustine, FLInadvertent retraction of the landing gear, and the instructor pilot's inadequate supervision of the flight.NTSB MIA89LA229Accident · No injuriesLimited investigationFinal reportBell 47G · Ponce, PRFailure of the aft tail rotor drive shaft.NTSB LAX89LA285Accident · No injuriesLimited investigationFinal reportCessna 185F · Fresno, CAFailure of the pilot to maintain directional control of the aircraft.NTSB LAX89FA275Accident · 4 fatalField investigationFinal reportMooney M20F · Livermore, CAThe pilot's decision to conduct low level night flight under low ceilings. Contributing factors were: the dark night, low ceiling, and high obstructions.NTSB DEN89LA198Accident · No injuriesLimited investigationFinal reportCessna 150-L · Logan, UTImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to lack of fuel. Factors related to the accident were: darkness and a fence in the emergency landing area.NTSB CHI89DEP11Accident · Minor injuriesFinal reportTierra II Panther 2 Plus · Tomah, WIThe pilot's premature liftoff, which resulted in a stall/mush and subsequently impact on the runway.NTSB BFO89FA069Accident · 3 fatalField investigationFinal reportBeech B50 · Church Creek, MDVFR flight into IMC and pilot disorientation, which resulted in the loss of aircraft control. Contributing to the accident was the pilot's lack of instrument experience, darkness, and the adverse weather condition.NTSB MKC89LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Leon, IABlockage of the engine air induction system by a field mouse nest. The nest was positioned so that it could not be seen during the pre-flight inspection. It became dislodged during the takeoff roll on the rough runway.NTSB LAX89LA284Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Santa Paula, CAFailure of the instructor pilot to adequately supervise the conduct of the flight and to take timely and effective corrective action to the student's improper control inputs.NTSB FTW89DRD13Accident · No injuriesFinal reportBell 47G-3B-1 · Rayville, LAFailure of the pilot to maintain sufficient rotor RPM. A factor related to the accident was: the cotton crop.NTSB ATL89DKJ10Accident · Serious injuriesFinal reportPiper PA-36-285 · Atmore, ALThe pilot's failure to maintain clearance from obstacles (the crop) during an agricultural spray run.NTSB ANC89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKPilot-in-command's improper fuel consumption calculations, improper inflight planning, and decisions.NTSB SEA89FA154Accident · 3 fatalField investigationFinal reportBeech C90 · Gold Beach, ORThe pilot's failure to initiate a go-around after emerging from a fog bank on a short final which resulted in inadequate airspeed and a stall. Contributing to the accident was the pilot's poor judgement in attempting the VFR approach in IMC conditions.NTSB MKC89LA184Accident · Minor injuriesLimited investigationFinal reportDormoy TKD Bathtub · Carlisle, MNFailure of the mixture control cable and inadequate maintenance (repair) by the pilot. The terrain conditions were considered to be contributing factors.NTSB DEN89FA197Accident · Serious injuriesField investigationFinal reportAerospatiale AS350D · Carson City, NVA failure of the gas generator turbine. Factors related to the accident were: the tailwind and the residential area in which the pilot was forced to land.NTSB BFO89LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Clendenin, WVInadequate preflight planning/preparation by the pilot which resulted in fuel exhaustion. The weather conditions, the pilot's delay in diverting to an alternate airport, and the light pole were contributing factors.NTSB ANC89LA147Accident · No injuriesLimited investigationFinal reportCessna 175 · Anchorage, AKFailure of the accessory drive (crankshaft) dowel pin and/or gear bolt, which resulted in the accessory drivegear becoming disconnected from the crankshaft.NTSB NYC89LA196Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Factoryville, PAInadequate preflight by the pilot and his misjudgement of the fuel supply, which resulted in fuel exhaustion. The ditch was a related factor.NTSB MIA89LA227Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe pilot's failure to follow the checklist and ensure that the elevator trim tab was adjusted properly for takeoff.NTSB MIA89LA226Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe pilot's failure to attain the proper touchdown point during landing.NTSB LAX89LA283Accident · 2 fatalLimited investigationFinal reportPiper PA-38-112 · Long Beach, CAThe pilot's inadequate airspeed during takeoff which led to an inadvertent stall. A factor was the excessive weight in the aircraft.NTSB LAX89LA282Accident · Serious injuriesLimited investigationFinal reportBeech B35 · San Diego, CALoss of engine power for undetermined reasons. Factors that related to the accident were: unavaliable altitude, remedial action not possible, unsuitable terrain, high vegetation, and the trees.NTSB SEA89LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Mulino, ORImproper installation and routing of the fuel pressure line and/or electrical wiring, due to improper maintenance, which resulted in mechanical binding of the elevator control column. The fence was considered to be a related factor.NTSB NYC89LA201Accident · No injuriesLimited investigationFinal reportCessna 182R · Warren, VTImproper flare by the pilot, and his improper recovery from a bounced landing.NTSB NYC89LA197Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-32 · Plymouth, CTImproper compensation for wind conditions by the pilot. A factor related to the accidetn was: the downdraft.NTSB MIA89LA228Accident · Serious injuriesLimited investigationFinal reportFokker F-28 MK4000 · Vero Beach, FLIn-flight encounter with unforecast turbulence, which resulted in injury of a flight attendant, who was not wearing a safety belt.NTSB MIA89LA225Accident · Minor injuriesLimited investigationFinal reportCocchiarella Buccaneer II · Clermont, FLImproper planning/decision by the pilot, which resulted in a subsequent collison with the ground, when the acft would not climb after takeoff. The high obstructions (trees) and high density altitude were considered to be contributing factors.NTSB LAX89LA281Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350D · Volcano, HIA catastrophic failure of the power turbine shaft and bearings. The failure was a result of oil starvation due to an excessively worn chip detector o-ring seal,inadequate maintenance and preflight. Contributing factor(s) was: the mountainous terrain.NTSB FTW89LA150Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAPilot's improper emergency procedures and flare that led to a hard landing and roll over. Factors in the accident were the pilot's decision to initiate an autorotation following an undetermined event and failure to maintain directional control during the…NTSB DEN89LA196Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Dove Creek, COImproper planning/decision by the pilot. Factors related to the accident were: high density altitude, uphill sloping runway, failure of the pilot to follow the checklist and use all of the available runway, and the rising terrain and obstruction (power line)…NTSB CHI89LA172Accident · No injuriesLimited investigationFinal reportCessna T-337D · Howell, MIThe pilot's poor preflight planning and inaccurate fuel consumption calculations. Contributing factor was maintenance personnel's not performing correct calibration of fuel gages.NTSB ATL89LA199Accident · No injuriesLimited investigationFinal reportHughes 269A · Saluda, SCStudent pilot's improper use of the flight controls during lift-off and inadequate supervision by the flight instructor.NTSB ATL89FA200Accident · No injuriesField investigationFinal reportBell 206B · Fruithurst, ALPilot's failure to maintain main rotor RPM while executing an autorotation which resulted in a hard landing. Contributing to the accident was the pilot's failure to follow autorotation procedures after the reported engine failure.NTSB ANC89LA146Accident · No injuriesLimited investigationFinal reportCessna 172 · Eureka Lodge, AKImproper planning/decision by the pilot. A contributing factor was the hump (uneven surface) on the runway.NTSB ANC89LA145Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Galbraith Lake, AKThe pilots failure to maintain direction control after aborting takeoff following failure of the tail landing gear tire.NTSB ANC89FA143Accident · No injuriesField investigationFinal reportPiper PA-19 · Anchorage, AKOperation with a known deficiency in the aircraft and water contamination of the fuel due to inadequate preflight preparation by the pilot. Factors related to the accident were: lack of suitable terrain for a forced landing and tree(s).NTSB NYC89LA198Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gardner, MAThe worn throttle arm.NTSB MKC89LA187Accident · No injuriesLimited investigationFinal reportBeech V35B · Concord, ARImproper installation of the alternator wiring harness by the pilot/owner which resulted in chafed wiring and a subsequent electrical fire. The uneven terrain was a contributing factor.NTSB CHI89FA173Accident · Serious injuriesField investigationFinal reportCessna 150M · Plainfield, ILThe pilot-in-command lost control of the aircraft following a premature lift-off resulting in an uncontrolled descent into the terrain.NTSB ANC89LA150Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Copper Center, AKThe selection of unsuitable terrain for landing by the pilot. He subsequently lost control of the airplane when he improperly applied hard braking during a wheel landing.NTSB CHI89FA174Accident · Serious injuriesField investigationFinal reportCessna 172P · Superior, WIThe failure of the pilot to maintain directional control.NTSB BFO89LA071Accident · No injuriesLimited investigationFinal reportRobinson R22 · Manassas, VAImproper use of the cyclic control by the student pilot and his failure to relinquish control of the helicopter to the instructor (CFI). A contributing factor was the student's lack of experience.NTSB SEA89LA151Accident · Minor injuriesLimited investigationFinal reportNavion A · Ely, NVImproper planning/decision by the pilot, which resulted in failure to obtain/maintain adequate airspeed to remain airborne after lift-off, and an inadvertent stall. Factors related to the accident were: the pilot's attempt to fly the aircraft with excessive…NTSB NYC89LA195Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Milbridge, MEFailure of the number 3 intake valve outer spring. The water (river) in the emergency landing area was a related factor.NTSB MIA89LA224Accident · No injuriesLimited investigationFinal reportBeech 18 · Greenwood, MSInadvertent wheels up landing by the pilot.NTSB LAX89DUJ09Accident · Minor injuriesFinal reportHiller UH-12E · Tolleson, AZAn engine failure due to water contamination in the fuel supply which preceded an autorotation and collision with the ground during night time conditions.