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 MIA92FA174Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Inverness, MSThe failure of the pilot in command to maintain airspeed above stall airspeed resulting in the aircraft stalling and entering a spin from which it descended uncontrolled to the ground.Sep 6, 1992 · N70734 · DestroyedNTSB LAX92LA378Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Chandler, AZThe pilot's misjudging the performance and weight and balance data of the helicopter prior to departure. Contributing to the accident was a failure of the pilot to jettison the chemical load.Sep 6, 1992 · N38099 · Substantial damageNTSB LAX92LA376Accident · No injuriesLimited investigationFinal reportCessna 205A · Gerlach, NVThe pilot misjudged the landing flare and failed to properly recover from the bounced landing.Sep 6, 1992 · N4825U · Substantial damageNTSB FTW92FA223Accident · 1 fatalField investigationFinal reportPiper PA-30 · Broussard, LAPilot's decision to fly into known adverse weather and the resultant in flight break up of the airplane.Sep 6, 1992 · N7065Y · DestroyedNTSB ANC92LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Sparrevohn, AKThe pilot's low pass between trees in crosswind conditions and inflight decision to conduct low altitude flight at a location that was too restricted for safe operation. Factors relating to the accident were: cross wind conditions and obstacles (trees).Sep 6, 1992 · N8699D · Substantial damageNTSB LAX92LA375Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Santa Monica, CAThe the pilot's poorly planned approach; his failure to select the proper touch down point; and inadequate remedial action.Sep 5, 1992 · N54566 · Substantial damageNTSB FTW92LA222Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Mcgehee, ARThe pilot's failure to maintain clearance.Sep 5, 1992 · N23207 · Substantial damageNTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.Sep 5, 1992 · N32677 · Substantial damageNTSB FTW92FA224Accident · 1 fatalField investigationFinal reportRobinson R22 · Alpine, TXFailure by the pilot-in-command, for unknown reasons, to maintain sufficient altitude to clear surrounding terrain. Factors were mountainous terrain and high density altitude.Sep 5, 1992 · N4073S · DestroyedNTSB DEN92FA091Accident · 2 fatalField investigationFinal reportBeech E-55 · Steamboat Sprin, COThe pilot becoming spatially disoriented and losing control of the airplane. Factors were: the pilot's disregard of the preflight weather briefing, his intentional VFR flight into instrument meteorological conditions, his lack of recent instrument time, and…Sep 5, 1992 · N12GG · DestroyedNTSB CHI92LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wheeling, ILMain landing gear collapse as a result of the failure of a landing gear hydraulic pump seal.Sep 5, 1992 · N9578B · Substantial damageNTSB CHI92LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Moran, MIThe pilot-in-command's improper selection of fuel tank resulting in fuel starvation. A factor was the pilot-in-command's encounter with unsuitable terrain.Sep 5, 1992 · N5572J · Substantial damageNTSB CHI92FA266Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Ness City, KSThe pilot-in-command's (CFI) failure to maintain control of the airplane.Sep 5, 1992 · N5272L · DestroyedNTSB CHI92DEE04Accident · No injuriesFinal reportWeatherly 201B · Chana, ILFracture of a connecting rod resulting in loss of engine power.Sep 5, 1992 · N2935W · Substantial damageNTSB BFO92LA124Accident · No injuriesLimited investigationFinal reportCessna 172XP · Factoryville, PAThe pilot's failure to maintain directional control.Sep 5, 1992 · N1FZ · DestroyedNTSB BFO92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Windham, CTThe pilot's improper IFR operation. Contributing was the pilot's instrument flight inexperience.Sep 5, 1992 · N3751R · DestroyedNTSB BFO92FA127Accident · 1 fatalField investigationFinal reportCessna A150L · Troy, MEFailure of the pilot to maintain proper altitude during an aerobatic manuever.Sep 5, 1992 · N6054J · DestroyedNTSB BFO92FA125Accident · 3 fatalField investigationFinal reportPiper PA-60-602P · Georgetown, DEThe pilot's failure to maintain airspeed, while circling to land, resulting in an inadvertent stall. Factors related to the accident were: the pilot's excessive maneuvering of the airplane and his insufficient altitude for recovery from the stall.Sep 5, 1992 · N3647T · DestroyedNTSB ATL92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22T · Headland, ALThe pilot's improper evaluation of wind conditions and selection of the wrong runway, which resulted in a loss of control during the landing roll. A factor to the accident was a gusting tail wind.Sep 5, 1992 · N8098C · Substantial damageNTSB ATL92LA175Accident · No injuriesLimited investigationFinal reportCessna 140 · Blairsville, GAA complete loss of engine power which resulted from two stuck exhaust valves.Sep 5, 1992 · N2059V · Substantial damageNTSB ANC92LA158Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Skwentna, AKPilot misjudged performance capability for tailwind condition considering aircraft load and terrain. Factors related to the accident were: terrain, takeoff airspeed not attained, aircraft performance, pilot overconfidence in aircraft and personal ability.Sep 5, 1992 · N5106H · Substantial damageNTSB ANC92LA157Accident · No injuriesLimited investigationFinal reportSikorsky S-58G · Port Alsworth, AKInflight engine compartment fire and post landing fire of undetermined origin.Sep 5, 1992 · N822G · DestroyedNTSB BFO92LA126Accident · 1 fatalLimited investigationFinal reportCessna 172E · Tuckahoe, NJVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the light conditions at dusk (or darkness), and the pilot's lack…Sep 4, 1992 · N3847S · DestroyedNTSB ATL92LA177Accident · No injuriesLimited investigationFinal reportAir Command Commander · Mars Hill, NCThe pilot's premature rotation before sufficient rotor speed had been attained to support flight. A factor was the rough sod airstrip.Sep 4, 1992 · N4235X · Substantial damageNTSB ATL92LA172Accident · No injuriesLimited investigationFinal reportAyres S-2R · Douglas, GAThe pilot's failure to check weather prior to the flight. A factor was the dark night.Sep 4, 1992 · N4007H · Substantial damageNTSB ANC92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Alsworth, AKThe improper maneuver that unported the low fuel tank. The unsuitable terrain at the site of forced landing was a factor.Sep 4, 1992 · N8420D · Substantial damageNTSB LAX92LA407Accident · No injuriesLimited investigationFinal reportCessna 172 · Inyokern, CAThe student pilot's failure to maintain directional control. Contributing to this accident was the student's pilot total lack of experience and the crosswind.Sep 3, 1992 · N4187F · Substantial damageNTSB DEN92LA090Accident · No injuriesLimited investigationFinal reportCessna A188 · Burlington, COFractured connecting rod. A factor was: the lack of suitable terrain for the forced landing.Sep 3, 1992 · N8041V · DestroyedNTSB DEN92FA089Accident · Serious injuriesField investigationFinal reportBell 206L3 · Bayfield, COFailure of the pilot-in-command to properly use the helicopter's performance data. Factors which contributed to the accident were: the adverse terrain and high density altitude.Sep 3, 1992 · N911NM · Substantial damageNTSB CHI92LA264Accident · No injuriesLimited investigationFinal reportCessna 170A · Angola, INFailure of the pilot to maintain directional control during landing rollout.Sep 3, 1992 · N9124A · Substantial damageNTSB CHI92LA263Accident · No injuriesLimited investigationFinal reportCessna 402B · Almont, MIExcessive fuel system pump pressure and corresponding excessive fuel pressure and the pilot not maintaining the best single engine climb speed.Sep 3, 1992 · N7882Q · Substantial damageNTSB BFO92LA122Accident · No injuriesLimited investigationFinal reportCessna 185 · Dover Foxcroft, MEInadequate servicing of the aircraft which resulted in the lack of hydraulic fluid and the consequent loss of brake presure.Sep 3, 1992 · N93766 · Substantial damageNTSB SEA92LA194Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · The Dalles, ORA misjudged approach. Factors to the accident were: inaccurate fuel consumption calculations and fuel exhaustion.Sep 2, 1992 · N1005B · Substantial damageNTSB MIA92T#A03Accident · No injuriesClass 3Final reportBell TH-13T · Lake Wales, FLSep 2, 1992 · N9596Z · Substantial damageNTSB MIA92LA172Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Homestead, FLThe failure of maintenance personnel to comply with a service bulletin, which allowed a cracked landing gear housing to go undetected, resulting in failure of the landing gear.Sep 2, 1992 · N975DA · Substantial damageNTSB MIA92LA171Accident · No injuriesLimited investigationFinal reportCessna 172M · Hernando, MSThe failure of the pilot in command to compensate for the crosswind condition, resulting in a ground loop. Contributing to the accident was the pilot's lack of experience in the type of aircraft.Sep 2, 1992 · N64001 · Substantial damageNTSB LAX92LA373Accident · No injuriesLimited investigationFinal reportCessna 170A · Holtville, CAThe pilot's encounter with the unforecasted dust devil.Sep 2, 1992 · N9923A · Substantial damageNTSB LAX92FA374Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Concord, CAThe following Probable Cause was modified on April18, 2007, as a result of new information provided to the NTSB. The improper installation of the 1.75 inch od plug in the crankshaft by unknown maintenance personnel which resulted in an inadvertent feathering…Sep 2, 1992 · N4305Y · DestroyedNTSB CHI92LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Crete, NEA premature lift-off and failure to perform remedial action. Lack of expereince in short field takeoffs was a factor.Sep 2, 1992 · N6480M · Substantial damageNTSB CHI92DEP05Accident · No injuriesFinal reportReif Avid Flyer · Shiocton, WIFailure of the pilot-in-command to obtain a proper climb rate, and his lack of total expereince in the type of airplane.Sep 2, 1992 · N4220X · Substantial damageNTSB BFO92LA121Accident · No injuriesLimited investigationFinal reportCessna 172H · New Braintree, MAWater contaminated fuel which resulted in the loss of engine power and the pilot's inadequate preflight inspection.Sep 2, 1992 · N2458L · Substantial damageNTSB ATL92LA174Accident · No injuriesLimited investigationFinal reportCessna 210M · Smithfield, NCThe pilot's operation of the airplane with known electrical deficiencies which resulted in a failure of the landing gear hydraulic powerpack. The pilot also failed to follow emergency procedures for lowering the landing gear. Factors were an inoperative…Sep 2, 1992 · N6979B · Substantial damageNTSB ATL92LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's inadequate compensation for existing wind conditions, which resulted in his inability to maintain a proper altitude. Factors were the turbulence and wind shear present at the time of the accident.Sep 2, 1992 · N4845Q · Substantial damageNTSB ANC92LA160Accident · No injuriesLimited investigationFinal reportDale Conover Tundra PUP · Beluga, AKThe inadequate preflight planning/preparation by the pilot. A factor was the pilot misjudged his clearance from the trees.Sep 2, 1992 · N2072Y · Substantial damageNTSB ANC92LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Ninilchik, AKThe student pilot entered a low altitude stall/mush during an airdrop maneuver. Factors contributing to the accident were: the low pass maneuver, and the improper altitude.Sep 2, 1992 · N1737D · DestroyedNTSB ANC92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Fort Yukon, AKFatigue failure of an engine cylinder precipitated by the pilot-in-command intentionally exceeding the engine performance ratings in order to sustain flight in the grossly overweight condition. A factor contributing to the accident was the high grass. A…Sep 2, 1992 · N8070Z · Substantial damageNTSB MIA92LA170Accident · No injuriesLimited investigationFinal reportHughes 269B · Long Beach, MSImproper collective and cyclic control input by the pilot-in-command during the forced landing following total loss of engine power due to undetermined reasons.Sep 1, 1992 · N9460F · Substantial damageNTSB MIA92FA173Accident · 2 fatalField investigationFinal reportBeech BE-A23-19 · Picayune, MSThe failure of the pilot in command to place the fuel selector on the fullest tank, resulting in an engine failure due to fuel starvation over unsuitable terrain.Sep 1, 1992 · N2377W · DestroyedNTSB LAX92LA372Accident · No injuriesLimited investigationFinal reportMaule M5-180C · San Jose, CAThe pilot's misjudged landing flare which resulted in a bounced landing and the pilot's improper recovery from the bounced landing.Sep 1, 1992 · N8070 · Substantial damageNTSB BFO92LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Great Barringto, MAThe pilot's failure to recover from a bounced landing. Factors related to the accident were the pilot's inadequate flare and failure to maintain directional control.Sep 1, 1992 · N4792M · Substantial damage