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 ANC93LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Wulik River, AKThe pilot's failure to maintain control of the airplane. A factor was the crosswind.Sep 3, 1993 · N2384D · Substantial damageNTSB SEA93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Missoula, MTThe loss of engine power from fuel exhaustion due to inadequate preflt planning/preparation by the PIC. A factor related to the accident was the rough/uneven terrain at the accident site.Sep 2, 1993 · N3305V · DestroyedNTSB SEA93LA188Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Three Forks, MTThe pilot's failure to maintain flying speed resulting in a stall/mush. The high density altitude and the pilot's failure to completely jettison his load were factors.Sep 2, 1993 · N21861 · DestroyedNTSB SEA93FA187Accident · 3 fatalField investigationFinal reportCessna 180 · Cheyenne, WYImproper in-flight planning/decison by the pilot, which resulted in exceeding the design stress limits of the aircraft after encountering adverse weather. The weather conditions were related factors.Sep 2, 1993 · N3120C · DestroyedNTSB MIA93LA187Accident · No injuriesLimited investigationFinal reportMooney M20J · Daytona Beach, FLContamination/blockage of the fuel injection control system.Sep 2, 1993 · N191ER · Substantial damageNTSB LAX93LA341Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Willows, CAthe pilot's failure to maintain directional control of the aircraft.Sep 2, 1993 · N39527 · Substantial damageNTSB FTW93IA250Incident · No injuriesIncident investigationFinal reportCessna A185F · Pilottown, LAThe pilot in command becoming physically incapacitated (heart attack).Sep 2, 1993 · N6279E · No damageNTSB CHI93IA352Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · St. Louis, MOa fatigue failure of the power transfer unit caused by a material defect which resulted in a total hydraulic system failure.Sep 2, 1993 · N918TW · No damageNTSB BFO93LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Centre Hall, PAThe pilot misjudged his airspeed and altitude which resulted in the pilot's failure to attain the proper touchdown point resultng in the airplane exiting the runway and colliding with the berm. A related factor was the location of the berm.Sep 2, 1993 · N2406U · Substantial damageNTSB BFO93LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28 · New Carlisle, OHThe pilot's delay in aborting the takeoff, and his failure to maintain directional control during the aborted takeoff.Sep 2, 1993 · N56975 · Substantial damageNTSB BFO93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Williamson, WVA fire in the cockpit area for undetermined reasons.Sep 2, 1993 · N31858 · DestroyedNTSB BFO93LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caribou, MELoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.Sep 2, 1993 · N7507P · Substantial damageNTSB BFO93LA149Accident · Serious injuriesLimited investigationFinal reportLach Bensen B-8M · Fall River, MAFATIGUE FAILURE OF THE GYROCOPTER'S MAIN ROTOR CONTROL ARM. fACTORS RELATED TO THE ACCIDENT WERE: A LOOSE CLAMP ON THE ROTOR CONTROL ARM, DUE TO INADEQUATE MAINTENANCE OR INSPECTION, WHICH RESULTED IN CHAFING OF THE CONTROL ARM.Sep 2, 1993 · N8447 · Substantial damageNTSB ANC93FA167Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Sanona Creek, AKThe pilot's failure to maintain flying speed during a downwind turn for landing. Factors contributing to the accident were: the overweight condition of the airplane, and failure to assure that the airplane complied with all applicable airworthiness…Sep 2, 1993 · N4713A · DestroyedNTSB ANC93LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Squirrel River, AKThe pilot improperly compensated for the wind conditions.Sep 1, 1993 · N4402Z · Substantial damageNTSB ANC93LA165Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Kijik River, AKThe pilot's failure to maintain a proper altitude during the low pass.Sep 1, 1993 · N71585 · Substantial damageNTSB ANC93LA164Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Delta River, AKThe pilots failure to maintain directional control during takeoff.Sep 1, 1993 · N10987 · Substantial damageNTSB NYC93LA181Accident · No injuriesLimited investigationFinal reportBeech 19 · Wolfboro, NHThe pilot's failure to abort the takeoff which resulted in an overrun of the runway. Factors were a dirt bank, and the pilot's premature lift off, his failure to attain adequate airspeed, and his lack of recency of experience.Aug 31, 1993 · N24685 · Substantial damageNTSB CHI93LA345Accident · No injuriesLimited investigationFinal reportBeech P35 · Ottumwa, IAan oil leak in the oil filter adapter. A factor was landing in a crop field.Aug 31, 1993 · N8527M · Substantial damageNTSB CHI93LA343Accident · No injuriesLimited investigationFinal reportCessna T210N · Lake In The Hil, ILChafing of a fuel system line.Aug 31, 1993 · N6649N · Substantial damageNTSB ANC93LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Victory, AKThe partial failure of the airplane's brake system. Factor was the intentional ground looping by the pilot-in-command.Aug 31, 1993 · N9016Y · Substantial damageNTSB ANC93FA161Accident · 3 fatalField investigationFinal reportDe Havilland DHC-2 · Iliamna, AKThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A factor in the accident was the inadequate recurrent training of the pilot by the operator/management.Aug 31, 1993 · N64273 · DestroyedNTSB NYC93LA183Accident · No injuriesLimited investigationFinal reportPiper PA-601 · Penn Yan, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with an obstacle and the ground. A factor is the pilot's diverted attention.Aug 30, 1993 · N60721 · Substantial damageNTSB LAX93LA376Accident · No injuriesLimited investigationFinal reportCessna 182G · Carson City, NV1) the pilot's failure to maintain an appropriate airspeed during an attempted go around, 2) his failure to retract the landing flaps, and 3) the resulting inadvertent entry into a stall/mush condition.Aug 30, 1993 · N2082R · Substantial damageNTSB FTW93LA249Accident · No injuriesLimited investigationFinal reportCessna T188C · Rockport, TXInadvertent stall/mush experienced by the pilot.Aug 30, 1993 · N2867J · Substantial damageNTSB CHI93IA382Incident · No injuriesIncident investigationFinal reportFairchild SA-227-AC · Grand Rapids, MNthe fractured aileron cable and other maintenance personnel's inadequate maintenance/adjustment.Aug 30, 1993 · N446MA · No damageNTSB CHI93IA346Incident · No injuriesIncident investigationFinal reportCessna 414A · Dickinson, NDthe total failure of the airplane's heater system combustion air pressure safety switch.Aug 30, 1993 · N36990 · Minor damageNTSB ANC93LA170Accident · 1 fatalLimited investigationFinal reportCessna 185 · Hulahula River, AKThe pilot in command's attempted VFR flight into IMC conditions. Factors contributing to the accident were the high terrain and the obscuration.Aug 30, 1993 · N70087 · DestroyedNTSB NYC93LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Mifflin, PAThe pilot's misjudgement of speed and distance, which resulted in a landing overrun of the runway. Factors were an embankment and the pilot not being able to abort the landing.Aug 29, 1993 · N2572U · Substantial damageNTSB NYC93LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Factoryville, PAThe pilot's inadequate preflight preparation by failing to properly set the stabilator trim tab.Aug 29, 1993 · N9249P · DestroyedNTSB NYC93FA177Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-40 · S. Charleston, WVwas improper emergency procedures by the pilot which resulted in the shutdown of an operative engine, following a power loss due to a failed torque sensor in the other engine, which resulted in a total power loss approach, landing, and overrun.Aug 29, 1993 · N965MA · DestroyedNTSB LAX93LA339Accident · Serious injuriesLimited investigationFinal reportMooney M-20M · Eureka, CAthe pilot's failure to attain the proper touch down point and the excessive airspeed.Aug 29, 1993 · N353CK · Substantial damageNTSB LAX93LA338Accident · No injuriesLimited investigationFinal reportBeech 95 · Kingman, AZthe fatigue cracking of the propeller blade retention screw. A factor was the maintenance service bulletins for the propeller were not performed on the accident airplane.Aug 29, 1993 · N9CE · Substantial damageNTSB FTW93LA247Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Prairie, TXThe fuel exhaustion induced power loss, the pilot's miscalculation of the amount of fuel required for the flight, and his failure to refuel. Factors were the dark night conditions and the lack of suitable terrain onto which a forced landing could be executed.Aug 29, 1993 · N471FT · Substantial damageNTSB DEN93LA106Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Palisade, COPartial power loss during approach for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 29, 1993 · N522BK · Substantial damageNTSB CHI93LA341Accident · No injuriesLimited investigationFinal reportCessna R182 · St Louis, MOthe pilot's delay in lowering the landing gear prior to touchdown.Aug 29, 1993 · N2623C · Substantial damageNTSB ANC93LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Happy Valley, AKThe pilot's improper preflight planning/decision, and his failure to maintain directional control of the airplane. A factor was the rough/uneven terrain.Aug 29, 1993 · N6819L · Substantial damageNTSB ANC93LA159Accident · 1 fatalLimited investigationFinal reportMorgan Steen Skybolt MI-2 · Nome, AKThe pilot delayed in recovering from the aerobatic maneuver.Aug 29, 1993 · N23JM · Substantial damageNTSB NYC93LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Cortland, NYThe student pilot's improper recovery from a bounced landing, resulting in a hard landing and collapse of the nose gear. A factor was the student pilot's inexperience.Aug 28, 1993 · N63626 · Substantial damageNTSB NYC93LA180Accident · No injuriesLimited investigationFinal reportMooney M20J · Kelley'S Island, OHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was the pilot's inadequate handling of the airplane.Aug 28, 1993 · N202WB · Substantial damageNTSB NYC93LA176Accident · Minor injuriesLimited investigationFinal reportChampion Citabria 7-GCBC · Fire Island, NYFailure of the #4 cylinder valve stem.Aug 28, 1993 · N5029L · Substantial damageNTSB MIA93WA186Accident · 1 fatalForeign investigationChristen Industries Pitts S-2B · Cayenne, French GuianaAug 28, 1993 · N60698 · DestroyedNTSB LAX93LA340Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cameron Park, CAThe pilot's failure to assure that the landing gear was down and locked. Factors relating to this accident were the alternator failure due to a broken wire and the low battery output.Aug 28, 1993 · N33195 · Substantial damageNTSB LAX93LA337Accident · No injuriesLimited investigationFinal reportCessna 208B · Los Angeles, CAThe inattention of the driver of a service truck to yield to aircraft and subsequent collision with the airplane as it crossed the service roadway.Aug 28, 1993 · N781FE · Substantial damageNTSB FTW93LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Tulsa, OKThe loss of engine power and engine fire for undetermined reasons.Aug 28, 1993 · N41377 · DestroyedNTSB DEN93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMImproper planning and decision making by the pilot in command in descending into a valley at an altitude providing no escape route in mountainous terrain.Aug 28, 1993 · N65655 · Substantial damageNTSB CHI93LA344Accident · No injuriesLimited investigationFinal reportBeech 19A · Troy, MOThe pilot's use of improper fuel in the airplane. Wet turf on the runway was a related factor.Aug 28, 1993 · N6130N · Substantial damageNTSB CHI93LA342Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Lexington, ILan inadequate climb airspeed by the pilot-in-command.Aug 28, 1993 · N3825V · DestroyedNTSB ANC93LA158Accident · No injuriesLimited investigationFinal reportHughes 369D · Mount Iliamna, AKThe pilot's improper in-flight planning/decision, and his delay in taking remedial action. Factors were the mountainous terrain and gusty winds.Aug 28, 1993 · N5074R · Substantial damageNTSB ANC93LA145Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Atigan Pass, AKThe pilot's improper inflight planning/decision and delay in taking remedial action.Aug 28, 1993 · N80303 · Substantial damage