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.

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…Aug 24, 1989 · N30806 · Substantial damageNTSB 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.Aug 24, 1989 · N6328B · Substantial damageNTSB ATL89LA201Accident · No injuriesLimited investigationFinal reportBeech A-36 · Charleston, SCThe pilot's failure to maintain clearance from other parked aircraft while taxiing.Aug 24, 1989 · N4534S · Substantial damageNTSB 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.Aug 23, 1989 · N80357 · Substantial damageNTSB 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.Aug 23, 1989 · N8517D · Substantial damageNTSB MIA89LA229Accident · No injuriesLimited investigationFinal reportBell 47G · Ponce, PRFailure of the aft tail rotor drive shaft.Aug 23, 1989 · N955B · Substantial damageNTSB LAX89LA285Accident · No injuriesLimited investigationFinal reportCessna 185F · Fresno, CAFailure of the pilot to maintain directional control of the aircraft.Aug 23, 1989 · N1562H · Substantial damageNTSB 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.Aug 23, 1989 · CFSAB · DestroyedNTSB 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.Aug 23, 1989 · N6697G · Substantial damageNTSB 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.Aug 23, 1989 · N22KK · Substantial damageNTSB 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.Aug 23, 1989 · N3688B · DestroyedNTSB 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.Aug 22, 1989 · N8AG · Substantial damageNTSB 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.Aug 22, 1989 · N1119E · Substantial damageNTSB 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.Aug 22, 1989 · N90463 · Substantial damageNTSB ATL89DKJ10Accident · Serious injuriesFinal reportPiper PA-36-285 · Atmore, ALThe pilot's failure to maintain clearance from obstacles (the crop) during an agricultural spray run.Aug 22, 1989 · N57581 · Substantial damageNTSB ANC89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKPilot-in-command's improper fuel consumption calculations, improper inflight planning, and decisions.Aug 22, 1989 · N202T · Substantial damageNTSB 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.Aug 21, 1989 · N25ST · DestroyedNTSB 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.Aug 21, 1989 · N812SS · Substantial damageNTSB 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.Aug 21, 1989 · N3596G · Substantial damageNTSB 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.Aug 21, 1989 · N7597W · DestroyedNTSB 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.Aug 21, 1989 · N6929E · Substantial damageNTSB 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.Aug 20, 1989 · N239 · Substantial damageNTSB 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.Aug 20, 1989 · N49938 · Substantial damageNTSB MIA89LA226Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe pilot's failure to attain the proper touchdown point during landing.Aug 20, 1989 · N757WX · DestroyedNTSB 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.Aug 20, 1989 · N2344N · DestroyedNTSB 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.Aug 20, 1989 · N8868A · Substantial damageNTSB 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.Aug 19, 1989 · N7358J · Substantial damageNTSB NYC89LA201Accident · No injuriesLimited investigationFinal reportCessna 182R · Warren, VTImproper flare by the pilot, and his improper recovery from a bounced landing.Aug 19, 1989 · N9335E · Substantial damageNTSB 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.Aug 19, 1989 · N414LF · Substantial damageNTSB 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.Aug 19, 1989 · N489US · No damageNTSB 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.Aug 19, 1989 · N127FB · Substantial damageNTSB 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.Aug 19, 1989 · N35970 · DestroyedNTSB 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…Aug 19, 1989 · N5006N · Substantial damageNTSB 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)…Aug 19, 1989 · N56654 · Substantial damageNTSB 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.Aug 19, 1989 · N33N · Substantial damageNTSB 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.Aug 19, 1989 · N8773F · Substantial damageNTSB 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.Aug 19, 1989 · N117V · Substantial damageNTSB 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.Aug 19, 1989 · N78254 · Substantial damageNTSB 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.Aug 19, 1989 · N88297 · Substantial damageNTSB 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).Aug 19, 1989 · N5417H · Substantial damageNTSB NYC89LA198Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gardner, MAThe worn throttle arm.Aug 18, 1989 · N65105 · Substantial damageNTSB 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.Aug 18, 1989 · N699T · Substantial damageNTSB 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.Aug 18, 1989 · N9329U · DestroyedNTSB 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.Aug 18, 1989 · N3877P · Substantial damageNTSB CHI89FA174Accident · Serious injuriesField investigationFinal reportCessna 172P · Superior, WIThe failure of the pilot to maintain directional control.Aug 17, 1989 · N98584 · Substantial damageNTSB 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.Aug 17, 1989 · N8557H · Substantial damageNTSB 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…Aug 16, 1989 · N8796H · Substantial damageNTSB 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.Aug 16, 1989 · N89JD · Substantial damageNTSB MIA89LA224Accident · No injuriesLimited investigationFinal reportBeech 18 · Greenwood, MSInadvertent wheels up landing by the pilot.Aug 16, 1989 · N5724M · Substantial damageNTSB 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.Aug 16, 1989 · N7086 · Substantial damage