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 LAX89LA166Accident · No injuriesLimited investigationFinal reportWaco QCF · Hollbrook, AZThe pilot's failure to maintain directional control of the airplane due to gusting wind conditions. The pilot did not adequately correct the situation before the airplane traveled into soft terrain.Apr 21, 1989 · N12428 · Substantial damageNTSB FTW89LA080Accident · No injuriesLimited investigationFinal reportCessna 182Q · Leakey, TXThe pilot's improper compensation for wind conditions, improper flare, and improper recovery from a bounced landing. Factors related to the accident were: the gusty wind condition and the pilot's lack of experience in this make and model of aircraft.Apr 21, 1989 · N182BS · Substantial damageNTSB SEA89LA073Accident · No injuriesLimited investigationFinal reportDonner/Parton Avid Flyer · Stanwood, WAAn ignition lead became disconnected from one cylinder, which resulted in a partial power loss. A factor related to the accident was: soft terrain in the touchdown area.Apr 20, 1989 · N4409D · Substantial damageNTSB SEA89LA072Accident · No injuriesLimited investigationFinal reportBeech A55 · Arlington, WAA premature/improper retraction of the landing gear by the second pilot (aircraft owner), who was occupying the right front seat.Apr 20, 1989 · N6866Q · DestroyedNTSB LAX89FA165Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Stockton, CAPoor judgement of the pilot by flying while physically impaired from consumption of alcohol & drugs, and his failure to maintain proper altitude. The light condition (at night) and the obstructions (power lines and building) were considered to be contributing…Apr 20, 1989 · N26198 · DestroyedNTSB SEA89FA074Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 · Pelican, AKImproper in-flight decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). The terrain and weather conditions were considered to be factors.Apr 19, 1989 · N62873 · DestroyedNTSB NYC89LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Gettysburg, PAThe pilot's poor preflight and in-flight planning in electing to continue the flight beyond the planned destination which resulted in fuel exhaustion.Apr 19, 1989 · N8745D · DestroyedNTSB NYC89FA121Accident · 1 fatalField investigationFinal reportBeech B19 · Augusta, MEFailure of the pilot to maintain the proper altitude during the approach. A factor related to the accident was: the pilot's psychological condition.Apr 19, 1989 · N2231L · DestroyedNTSB FTW89DRA04Accident · No injuriesFinal reportAir Tractor AT-502 · Ganado, TXLoss of directional control for an unknown reason.Apr 19, 1989 · N7320C · Substantial damageNTSB DEN89LA111Accident · No injuriesLimited investigationFinal reportCessna 170A · Kalispell, MTThe pilot's failure to maintain control of the airplane during the landing flare and rollout. Contributing to the accident was the pilot's lack of proficiency with only 4 hours of flight time in the preceding 90 day period.Apr 19, 1989 · N5414C · Substantial damageNTSB DEN89LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Kindred, NDThe pilot's failure to compensate for the wind conditions during the takeoff. Contributing to the accident were the crosswind conditions.Apr 19, 1989 · N527Y · Substantial damageNTSB BFO89LA030Accident · No injuriesLimited investigationFinal reportCessna 150F · New Cumberland, WVThe pilot's failure to compensate for crosswind conditions during an attempted go-around. Contributing factors were the crosswind condition and the pilot's low level of experience.Apr 19, 1989 · N3570L · Substantial damageNTSB MKC89LA092Accident · No injuriesLimited investigationFinal reportVestal Quickie Q2 · St Joseph, MOThe pilot's improper flare and failure to maintain directional control of the aircraft. A factor related to the accident was: the pilot's lack of experience in this make and model of aircraft.Apr 18, 1989 · N14VV · Substantial damageNTSB LAX89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fresno, CAThe pilot's inflight decision to abort the takeoff and land in a field. Contributing to the accident was the fence post that the aircraft collided with during the landing roll.Apr 18, 1989 · N1490T · Substantial damageNTSB SEA89LA071Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Grangeville, IDA partial power loss due to a blower failure. A factor related to the accident was the soft field condition.Apr 17, 1989 · N4340S · Substantial damageNTSB NYC89LA120Accident · No injuriesLimited investigationFinal reportCessna 172 · So. Bethlehem, NYThe pilots misjudgement of landing distance which resulted in the failure to touchdown at a proper touchdown point. The pilot also failed to perform a go-around.Apr 17, 1989 · N6105E · Substantial damageNTSB MIA89TL#04Accident · Minor injuriesClass 3Final reportBell 206B · Ochopee, FLApr 17, 1989 · N2210W · DestroyedNTSB MIA89LA133Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Miami, FLThe unqualified persons failure to maintain clearance from the fence. Pressure induced by others, lack of experience, and over confidence in personal ability are contributing factors to this accident.Apr 17, 1989 · N342L · Substantial damageNTSB FTW89LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Athens, TXFuel exhaustion due to inadequate preflight by the pilot.Apr 17, 1989 · N50703 · Substantial damageNTSB FTW89FA151Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Junction, TXContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, which resulted in his failure to maintain control of the aircraft due to spatial disorientation. The weather conditions and his self-induced pressure were factors.Apr 17, 1989 · N8785V · DestroyedNTSB DEN89LA109Accident · No injuriesLimited investigationFinal reportCessna 310E · Glenwood Spgs, COInadequate compensation for the wind conditions by the pilot, resulting in a loss of control of final approach. Contributing to the accident was the downdraft.Apr 17, 1989 · N4127G · Substantial damageNTSB CHI89TL#02Accident · No injuriesClass 3Final reportBellanca Bgcbc · Shell Lake, WIApr 17, 1989 · N7775S · Substantial damageNTSB ATL89FA130Accident · Serious injuriesField investigationFinal reportBell UH-1E · Aiken, SCImproper installation of a tail rotor pitch change crosshead retention bolt by the company mechanic, which resulted in loosening of the bolt and eventual failure of the tail rotor assembly/blade and subsequent loss of control. Trees at the crash site…Apr 17, 1989 · N118HS · Substantial damageNTSB ANC89LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Kenai, AKImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion.Apr 17, 1989 · N6479L · Substantial damageNTSB MIA89FA132Accident · 1 fatalField investigationFinal reportCoutz Quickie Q-2 · Lake City, FLAircraft control was lost for an unknown reason.Apr 16, 1989 · N13QT · DestroyedNTSB LAX89LA162Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAThe pilots improper use of carburetor heat in conditions that were conducive to the formation of carburetor ice.Apr 16, 1989 · N84745 · Substantial damageNTSB FTW89FA081Accident · Serious injuriesField investigationFinal reportHead Balloons AX8-88 · Troy, TXImproper planning/decision by the pilot, and inadequate supervision by the check pilot, which resulted in their failure to maintain clearance from the tree during the landing. Factors related to the accident were: the high wind & tree(s).Apr 16, 1989 · N4510H · Substantial damageNTSB SEA89LA070Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4 · Yamhill, ORPilot displayed poor inflight planning and preparation for the flight. The pilot did not adequately compensate for the wind conditions resulting in an intentional gear up landing.Apr 15, 1989 · N2990P · Substantial damageNTSB NYC89LA118Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · W.Mifflin, PAThe improper level off of the aircraft by the pilot which resulted in a hard landing and subsequent gear collapse.Apr 15, 1989 · N8468H · Substantial damageNTSB MKC89LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roseau, MNFuel starvation due to fuel ice.Apr 15, 1989 · N23702 · Substantial damageNTSB MIA89LA131Accident · No injuriesLimited investigationFinal reportCessna 182P · Tavernier, FLFailure of the pilot to maintain runway alignment and retract the flaps to the recommended setting during the go-around.Apr 15, 1989 · N7298N · Substantial damageNTSB LAX89LA161Accident · No injuriesLimited investigationFinal reportCessna 175 · Victorville, CAThe pilot's failure to conduct an adequate preflight and assure the proper quantity of fuel on board for the proposed flight.Apr 15, 1989 · N8174T · Substantial damageNTSB LAX89FA160Accident · Minor injuriesField investigationFinal reportSikorsky S-58ET · Santa Ana, CAFailure of the landing gear resulting from excessive loading during ground operations, and fatigue cracking.Apr 15, 1989 · N1168U · Substantial damageNTSB FTW89LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Addison, TXThe inadequate aircraft handling by the student pilot, where she allowed the airplane to start to porpoise, and then did not correct it.Apr 15, 1989 · N4870B · Substantial damageNTSB CHI89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INThe student pilot's failure to compensate for the crosswind condition and maintain directional control during the landing. The airplane departed the runway and nosed over in soft terrain. Contributing to the accident was the student's lack of recent…Apr 15, 1989 · N9223T · Substantial damageNTSB CHI89DET04Accident · 1 fatalFinal reportAmerican AA-1A · Bluffton, INInadequate airspeed resulting in a stall/spin by the pilot. Factors related to the accident were: a tailwind and wrong runway selected by the pilot.Apr 15, 1989 · N9479L · Substantial damageNTSB BFO89FA027Accident · 1 fatalField investigationFinal reportCessna 152 · West Chicago, ILImproper instruction by the student's flight instructor regarding the execution of s-turns on final approach to increase spacing and the retraction of flaps fully when executing a go-around and the failure of the student pilot to maintain adequate flying…Apr 15, 1989 · N93748 · DestroyedNTSB ATL89LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Gratis, OHThe foreign material (bird nest) in the engine compartment, and failure of the dual student or instructor pilot (CFI) to identify and remove it during their preflight inspection of the aircraft. Soft terrain in the emergency landing area and smoke from the…Apr 15, 1989 · N757HJ · Substantial damageNTSB ATL89FA131Accident · 2 fatalField investigationFinal reportMooney M20F · Lynch, KYContinued VFR flight by the pilot into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions, terrain, and the pilot's lack of instrument experience.Apr 15, 1989 · N9252V · DestroyedNTSB SEA89LA086Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355-F2 · Las Vegas, NVThe pilot's poor inflight decision in selecting an unsuitable area for practice landings and the pilot's inadequate visual lookout resulting in a tail rotor strike and loss of antitorque control.Apr 14, 1989 · N225CC · Substantial damageNTSB SEA89LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Arlington, ORThe student pilot touched down too FAR down the runway to allow him to stop before running into a trailer.Apr 14, 1989 · N4811D · Substantial damageNTSB NYC89LA117Accident · No injuriesLimited investigationFinal reportCessna 172M · Palmyra, PAThe pilot misjudged the airspeed and distance during the landing.Apr 14, 1989 · N9946Q · Substantial damageNTSB MKC89FA090Accident · 2 fatalField investigationFinal reportPiper J-3 · Oak Grove, MOThe pilot's attempt to takeoff with the aircraft over its allowable takeoff weight and out of the center of gravity limits.Apr 14, 1989 · N23227 · DestroyedNTSB LAX89LA169Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Bolinas, CAThe pilot's poor preflight planning in that he did not accurately account for the fuel on board the aircraft as a basis for fuel consumption calculations thereby causing the engine to stop producing power because of a lack of fuel. Contributing to the…Apr 14, 1989 · N14490 · Substantial damageNTSB DEN89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Milbank, SDFailure by the pilot to assure adequate removal of frost from the aircraft which resulted in a stall/mush.Apr 14, 1989 · N8272W · Substantial damageNTSB ANC89IA059Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-6-100 · Barrow, AKThe propagation of a fatigue crack from multiple origins due to manufacturing defects in the elevator bellcrank mounting quadrant.Apr 14, 1989 · N100AP · No damageNTSB NYC89LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Matawan, NJThe pilot's inadequate action after encountering tailwind conditions during landing.Apr 13, 1989 · N43663 · Substantial damageNTSB MKC89LA089Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARImproper planning/decision by the pilot, and his misjudgement of clearance between the airplane, wires, and the ground during the aerial application maneuver. Factors relating to the accident were: the dirty windshield, sunglare, transmission line (wires),…Apr 13, 1989 · N7245 · Substantial damageNTSB MIA89LA130Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Lakeland, FLThe pilot's failure to maintain directional control, which resulted in an inadvertent ground loop.Apr 13, 1989 · N15HB · Substantial damageNTSB MIA89LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Fort Pierce, FLFailure of the number five cylinder. Factors related to the accident were: the proximity of homes in the area, which precluded jettisoning of the chemical load, and high vegetation in the emergency landing area.Apr 13, 1989 · N3159D · Substantial damage