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 BFO94LA020Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Rockland, ME1) The pilot's failure to maintain adequate rotor RPM, 2) the pilot's failure to maintain directional control on landing, resulting in a dynamic rollover.Nov 27, 1993 · N8380J · Substantial damageNTSB SEA94LA037Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Sublimity, ORThe pilot's failure to maintain clearance from unmarked transmission wires. Factors include the pilot's inadequate visual lookout, and unmarked wires in the area of operation.Nov 26, 1993 · N59366 · Substantial damageNTSB MIA94WA032Accident · No injuriesForeign investigationMcDonnell Douglas DC10-30 · Buenos Aires, ArgentinaNov 26, 1993 · YV135 · Substantial damageNTSB MIA94LA029Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Moore Haven, FLFailure of the pilot-in-command to maintain aircraft control following loss of engine power for undetermined reasons.Nov 26, 1993 · N130HA · Substantial damageNTSB LAX94LA060Accident · Serious injuriesLimited investigationFinal reportAlbrecht Polywagon · Vacaville, CAthe pilot's failure to maintain control of the aircraft during a go-around. Factors in the accident were the wind shear conditions and the pilot's failure to adequately balance the fuel load during the flight.Nov 26, 1993 · N320PW · Substantial damageNTSB LAX94LA057Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Buckeye, AZA loss of engine power due to fuel system contamination. A factor in the accident was the soft terrain in the landing area.Nov 26, 1993 · N50412 · Substantial damageNTSB LAX94FA058Accident · 3 fatalField investigationFinal reportSiai-Marchetti F-260 · Santa Monica, CAthe dual student pilot's failure to maintain minimum air speed in flight which resulted in an inadvertent stall/spin. Contributing to the accident was the improper weight and balance, inadequate altitude, and inadequate supervision.Nov 26, 1993 · N126MJ · DestroyedNTSB FTW94FA038Accident · 2 fatalField investigationFinal reportCessna T303 · Rogers, ARThe pilot's continued flight into known adverse weather conditions, and the ensuing inadvertent stall. Factors were the icing conditions, the fog, the drizzle, the dark night light conditions, and the pilot's disregard for the forecasted weather conditions.Nov 26, 1993 · N2297C · DestroyedNTSB BFO94LA019Accident · Serious injuriesLimited investigationFinal reportMartin Streak Shadow · Mannington, WVThe pilot's failure to maintain clearance from the surrounding terrain.Nov 26, 1993 · N106JM · DestroyedNTSB BFO94LA018Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Stowe, VTThe pilot did not follow the emergency procedure after loss of power in the right engine, by failing to feather the right engine and failing to maintain minimum single-engine control speed. A factor related to the accident was: failure of the pilot to adhere…Nov 26, 1993 · N4VG · DestroyedNTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.Nov 26, 1993 · N7702U · Substantial damageNTSB MIA94LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Jacksonville, FLThe improper positioning of the fuel selector by the pilot-in- command resulting in fuel starvation.Nov 25, 1993 · N89900 · Substantial damageNTSB FTW94LA039Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Mancos, COFuel exhaustion induced power loss and the pilot's inadequate preflight inspection, during which he failed to insure that the airplane had been refueled to capacity. A factor was the lack of suitable terrain for a forced landing.Nov 25, 1993 · N8833T · Substantial damageNTSB MIA94LA027Accident · 1 fatalLimited investigationFinal reportThompson Bushby Mustang II · Madison, MSAn engine failure for undetermined reasons.Nov 24, 1993 · N38BT · DestroyedNTSB BFO94FA017Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Ravenna, OHThe pilot attempted to fly the airplane with known deficiencies in the attitude indicator and became spatially disoriented during the takeoff climb. Factors in the accident were the low ceiling, night conditions, and an inaccurate attitude indicator.Nov 24, 1993 · N8467H · DestroyedNTSB FTW94WA073Accident · Minor injuriesForeign investigationPiper Aerostar 601P · Campeche, MexicoNov 23, 1993 · N32RG · DestroyedNTSB SEA94LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Brookings, ORThe pilot's inadequate preflight planning/preparation, and icing of the induction air filter/screen. Factors include weather conditions conducive to icing, and rough/uneven terrain in the area of attempted landing.Nov 22, 1993 · N8829J · Substantial damageNTSB SEA94FA034Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Mountain Home, IDThe pilot's intentional suicide and impairment from consumption of alcohol.Nov 22, 1993 · N84PM · DestroyedNTSB LAX94FA056Accident · 2 fatalField investigationFinal reportCessna 172M · Julian, CAThe pilot's failure to maintain aircraft control. Factors in this accident were: 1) the dark night and lack of ambient light which resulted in the pilot inadvertently flying from visual meteorological conditions into instrument meteorological conditions; 2)…Nov 22, 1993 · N5312R · DestroyedNTSB BFO94LA016Accident · No injuriesLimited investigationFinal reportTaylorcraft J-2 · Pittstown, NJThe pilot failed to maintain a proper glidepath. A factor in the accident was the presence of sunglare.Nov 22, 1993 · N19565 · Substantial damageNTSB MIA94WA025Accident · No injuriesForeign investigationBeech BE-80 · Guatemala City, GuatemalaNov 21, 1993 · TGACP · DestroyedNTSB MIA94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Labelle, FLThe pilot-in-command exceeding the structural limits of the airplane's design limits by in-flight over-stress that resulted in damage to the gear extension system, fuselage and control surfaces.Nov 21, 1993 · N5755P · Substantial damageNTSB LAX94LA055Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Santa Paula, CAThe pilot's failure to follow proper procedures/directives prohibiting night operations at the airport and failure to maintain the proper glidepath. The pilot's diverted attention was a factor in this accident.Nov 21, 1993 · N6405Q · Substantial damageNTSB CHI94FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172I · Kalamazoo, MIUndetermined.Nov 21, 1993 · N35549 · DestroyedNTSB BFO94FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Northampton, MAFailure of the air traffic control (ATC) facility to identify and provide the required traffic information to the jump aircraft before release of the jumper(s). A factor related to the accident was: inadequate visual lookout by the pilot of the jump aircraft.Nov 21, 1993 · N3011F · DestroyedNTSB ATL94LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kinston, NCWas the student pilot's failure to maintain aircraft control during the go around. A factor was the wind gusts which occurred at the time of the accident.Nov 21, 1993 · N5340Q · Substantial damageNTSB LAX94LA066Accident · No injuriesLimited investigationFinal reportYakovlev YAK-55M · Greenfield, CAUndetermined.Nov 20, 1993 · N7090L · Substantial damageNTSB LAX94LA054Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAa fatigue failure of the torsion-tension bar pin due to fretting corrosion. A factor in this accident was an inadequate quality of material utilized in the manufacture of the pin.Nov 20, 1993 · N161HA · Substantial damageNTSB BFO94FA013Accident · 3 fatalField investigationFinal reportBell 206L-1 · Portland, METhe pilot's continued VFR flight into instrument meteorological conditions, and his failure to assure that adequate fuel was available to complete the flight, resulting in a loss of engine power due to fuel exhaustion. Factors which contributed to the…Nov 20, 1993 · N911ME · DestroyedNTSB ATL94LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Maryville, TNThe pilot's inadequate inflight planning, which resulted in fuel exhaustion prior to reaching the planned destination.Nov 20, 1993 · N420FL · DestroyedNTSB ANC94LA019Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe frozen throttle cable due to moisture.Nov 20, 1993 · N7586Z · Substantial damageNTSB MIA94LA024Accident · No injuriesLimited investigationFinal reportCessna U206F · Tampa, FLWas the improper overhaul and inspection of the engine by company maintenance personnel.Nov 19, 1993 · N8260Q · Substantial damageNTSB LAX94T#A02Accident · No injuriesClass 3Final reportCessna C206 · Chinle, AZNov 19, 1993 · N4517M · Substantial damageNTSB LAX94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Compton, CAwere the noncertificated student pilot's misjudged flare altitude, improper recovery from a bounced landing, and improper use of the left brake. The student pilot's lack of total experience and panic were factors in this accident.Nov 19, 1993 · N5312L · Substantial damageNTSB LAX94LA051Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-1B-2 · Las Vegas, NVWere the fuel injection line contamination resulting in fuel starvation; the pilot's inadequate 100-hour inspection; the pilot's improper decision to return to the airport at a low altitude; and his failure to maintain the proper airspeed which resulted in a…Nov 19, 1993 · N42597 · DestroyedNTSB CHI94GA038Accident · 1 fatalFinal reportHughes 369HS · Antonia, MOThe pilot's failure to maintain proper altitude. A factor was the dark night.Nov 19, 1993 · N9179F · Substantial damageNTSB SEA94LA036Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Pasco, WAThe pilot in command's failure to maintain clearance with the irrigation sprinkler system.Nov 18, 1993 · N8818Q · DestroyedNTSB NYC94FA027Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Kinnelon, NJThe loss of engine power for undetermined reasons.Nov 18, 1993 · N43791 · DestroyedNTSB LAX94LA050Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAwere the CFI's inadequate supervision of the flight and his delay in taking remedial action. The dual student's excessive taxi speed and the worn right brake lining were factors in this accident.Nov 18, 1993 · N9620B · 2 aircraft · Substantial damageNTSB FTW94FA036Accident · 2 fatalField investigationFinal reportCessna 152 · Guthrie, OKWas the pilot-in-command continued VFR flight into IMC. A factor was fog.Nov 18, 1993 · N45968 · Substantial damageNTSB SEA94LA033Accident · No injuriesLimited investigationFinal reportCessna C-172N · Idaho Falls, IDThe pilot's failure to attain the proper touchdown point. Factors include tailwind conditions and an airport perimeter fence.Nov 17, 1993 · N4713D · Substantial damageNTSB LAX94LA049Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAwas the student pilot's improper use of the rudder. The student pilot's lack of total experience was a factor in this accident.Nov 17, 1993 · N2346G · Substantial damageNTSB FTW94IA035Incident · No injuriesIncident investigationFinal reportGrumman G159 · Pineville, LAAn encounter with a wet microburst, on final approach at 200 feet AGL, which exceeded the performance capability of the aircraft.Nov 16, 1993 · N806W · Minor damageNTSB BFO94LA012Accident · No injuriesLimited investigationFinal reportAngel Elbert S JR Quickie 200 · North Kingston, RILoss of engine power due to undetermined reasons.Nov 16, 1993 · N687EA · DestroyedNTSB ATL94LA019Accident · Serious injuriesLimited investigationFinal reportBell-Carson 47G-SUPER C-4 · Eufaula, ALThe pilot's failure to maintain aircraft control. A factor was the pilot's limited helicopter flight experience.Nov 16, 1993 · N614X · Substantial damageNTSB SEA94LA042Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Mesa, WAThe pilot's improper flare. Factors include excessive airspeed while approaching the flare.Nov 15, 1993 · N1181W · Substantial damageNTSB MIA94LA023Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Orlando, FLThe failure of the pilot-in-command of the other aircraft to maintain a visual lookout and clearance between aircraft.Nov 15, 1993 · N91WW · 2 aircraft · Substantial damageNTSB LAX94LA045Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Florence, AZthe pilot's poor inflight planning and decision making by continuing the flight into adverse weather conditions. Factors contributing to this accident were: not obtaining a preflight weather briefing, not following the airplane flight manuals, and exceeding…Nov 15, 1993 · N9MP · DestroyedNTSB LAX94FA047Accident · 1 fatalField investigationFinal reportPiper PA-30 · Brea, CAThe pilot's choice of an inadequate cruise altitude over rolling hill terrain which resulted in an in-flight collision with helium balloons and an in-flight loss of control for undetermined reasons. A factor in the accident was the pilot's inadequate visual…Nov 15, 1993 · N8238Y · DestroyedNTSB FTW94FA034Accident · Serious injuriesField investigationFinal reportCessna 172N · Fort Collins, COPower loss due to throttle linkage disconnect. Factors were missing cotter key, improper maintenance, and the lack of suitable terrain for the forced landing.Nov 15, 1993 · N4829E · Destroyed