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 NYC93LA175Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Meriden, CTThe loss of engine power for undetermined reasons.Aug 27, 1993 · N269Q · Substantial damageNTSB NYC93LA174Accident · Serious injuriesLimited investigationFinal reportCameron HAB-N90 · Niagara Falls, NYThe inadequate bracing of the passenger for landing which resulted in a fall.Aug 27, 1993 · N1192W · No damageNTSB MIA93LA185Accident · Serious injuriesLimited investigationFinal reportKeuthan Buccaneer II · Cocoa, FLFailure of maintenance personnel to properly reinstall a bolt and nut in the elevator control linkage, which resulted in a disconnect of the linkage and loss of elevator control.Aug 27, 1993 · N693KA · Substantial damageNTSB MIA93FA184Accident · 1 fatalField investigationFinal reportReher, Kent O. RV 6 · Grand Ridge, FLUndetermined.Aug 27, 1993 · N220KM · DestroyedNTSB LAX93FA335Accident · 2 fatalField investigationFinal reportBeech D-35 · Alpine, CAThe failure of the pilot to maintain direction control during the initial takeoff climb which placed an obstruction in the airplane's takeoff flight path and a subsequent inadvertent stall. A factor in the accident was the existing crosswind.Aug 27, 1993 · N2988B · DestroyedNTSB CHI93LA340Accident · No injuriesLimited investigationFinal reportRobinson R22 · Bethalto, ILthe pilot-in-command's not maintaining rotor RPM.Aug 27, 1993 · N9071S · Substantial damageNTSB CHI93LA339Accident · No injuriesLimited investigationFinal reportCessna 172L · Curryville, MOImproper preflight planning and procedures by the pilot-in-command which resulted in fuel exhaustion.Aug 27, 1993 · N25BK · Substantial damageNTSB BFO93WA148Incident · No injuriesForeign investigationBoeing 747-100 · Milan, ItalyAug 27, 1993 · N4729U · No damageNTSB ATL93LA148Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Knoxville, TNInadequate annual inspection procedures for the fuel system, which resulted in fuel starvation due to blockage of the fuel floscan transducer. A factor was insufficient FAA inspection standards/requirements.Aug 27, 1993 · N7733R · Substantial damageNTSB SEA93FA186Accident · No injuriesField investigationFinal reportDassault DA-10 · Hailey, IDThe pilot-in-command's improper procedures. Factors include failure of an electrical relay, inoperative thrust reverser, poor crew coordination, and the second-in-command's improper procedures.Aug 26, 1993 · FBYCV · Substantial damageNTSB NYC93LA173Accident · Serious injuriesLimited investigationFinal reportCameron Bieu/V-65 · Lewiston, NYThe pilot's failure to maintain adequate clearance, which resulted in an inflight collision with a light pole.Aug 26, 1993 · N75192 · Substantial damageNTSB NYC93LA168Accident · No injuriesLimited investigationFinal reportPiper PA-25-225 · Chesapeake, VAThe loosening of the crankshaft geardrive as a resulted of a sheared bolt and guide pin which resulted in the loss of engine power. A factor was a forced landing on a crop field.Aug 26, 1993 · N9556P · Substantial damageNTSB LAX93FA333Accident · No injuriesField investigationFinal reportAero Commander 690A · Bishop, CAa loss of control and upset due to an inadequate adjustment of the ailerons and aileron trim tab by company maintenance personnel that resulted in a partial failure of the right horizontal stabilizer.Aug 26, 1993 · N706KC · Substantial damageNTSB FTW93LA246Accident · No injuriesLimited investigationFinal reportCessna T210N · Springdale, ARThe loss of engine power due to fuel starvation and the improper use of the fuel selector. Factors were the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.Aug 26, 1993 · N6142Y · Substantial damageNTSB CHI93LA338Accident · No injuriesLimited investigationFinal reportBeech 19 · Elkhart, INinadequate remedial action by the flight instructor. Factors related to the accident were the excessive descent rate and the overload failure of the landing gear.Aug 26, 1993 · N1914L · Substantial damageNTSB ANC93LA157Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Beaver Creek, AKThe improper altitude flown by the pilot in command.Aug 26, 1993 · N7637S · Substantial damageNTSB SEA93T#A03Accident · No injuriesClass 3Final reportBell 206L-1 · Crowheart, WYAug 25, 1993 · N2715X · Substantial damageNTSB SEA93LA184Accident · No injuriesLimited investigationFinal reportCessna 206B · Challis, IDInadequate compensation for wind conditions. The downdraft was a factor.Aug 25, 1993 · N3431L · Substantial damageNTSB MIA93FA183Accident · Serious injuriesField investigationFinal reportCessna 402C · Andytown, FLThe failure of the pilot to feather the propeller when the engine lost power, and his failure to follow the emergency procedure checklist. Contributing to the accident was the inadequate design of the fuel tank float valves which allowed for excessive wear…Aug 25, 1993 · N206RH · Substantial damageNTSB LAX93LA336Accident · No injuriesLimited investigationFinal reportContinental Copters Mark 5 · San Juan Bautis, CAthe pilot's failure to maintain sufficient altitude to clear the crops. The pilot's diverted attention during the aerial application flight is a factor in this accident.Aug 25, 1993 · N9078T · DestroyedNTSB FTW93FA245Accident · 1 fatalField investigationFinal reportAir Tractor AT-402 · La Barre, LALoss of control for undetermined reasons.Aug 25, 1993 · N1508X · DestroyedNTSB CHI93DEP05Accident · Minor injuriesFinal reportBell 47-G5 · Fulton, WIthe failure (fracture) of the number one cylinder intake valve retainer (keeper).Aug 25, 1993 · N1464W · Substantial damageNTSB ATL93LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108/U · Mccaysville, GAThe loss of engine power for undetermined reasons.Aug 25, 1993 · N5061Z · Substantial damageNTSB SEA93LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Enumclaw, WAThe pilot's delayed remedial action. Factors include a wet, downhill, grass runway during the abort.Aug 24, 1993 · N9148 · DestroyedNTSB CHI93LA337Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Saint James, MIImproper planning/decision by the pilot. Factors related to the accident were: the unfavorable wind, and high obstructions near the end of the runway.Aug 24, 1993 · N479CB · Substantial damageNTSB BFO93T#173Accident · No injuriesClass 3Final reportBell 206L-3 · Fairfax, VAAug 24, 1993 · N207FC · Substantial damageNTSB BFO93FA147Accident · No injuriesField investigationFinal reportMooney M20B · Landover, MDFatigue failure of a propeller blade, which resulted in severe engine vibration and subsequent damage to the airplane. The lack of suitable terrain for a forced landing was a related factor.Aug 24, 1993 · N74580 · Substantial damageNTSB SEA93LA181Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Auburn, WAFailure of the connecting rod bolt. The high vegetation was a factor.Aug 23, 1993 · N9785C · Substantial damageNTSB NYC93LA172Accident · 1 fatalLimited investigationFinal reportBellanca 7ECA · Ashland, NHThe pilot's improper decision to leave the airplane unattended with the engine operating.Aug 23, 1993 · N82819 · No damageNTSB MIA93FA182Accident · 1 fatalField investigationFinal reportCessna T337G · Ormond Beach, FLWater contamination in the fuel, which resulted in loss of power in the front engine as the pilot was attempting flight with a known problem in the rear engine, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.…Aug 23, 1993 · N5CP · DestroyedNTSB LAX93LA334Accident · No injuriesLimited investigationFinal reportCessna A150M · Sacramento, CAThe dual student pilot's failure to maintain directional control, improper use of the flight controls, and failure to relinquish the flight controls to the CFI. The soft dirt was a factor in this accident.Aug 23, 1993 · N9861J · Substantial damageNTSB FTW93FA244Accident · 2 fatalField investigationFinal reportBusby Celebrity · Perry, OKThe pilot's failure to maintain airspeed due to alcohol impairment. A factor which contributed to the accident was the pilot performing aerobatics at a altitude inadequate to recover from a stall.Aug 23, 1993 · N2828 · DestroyedNTSB SEA93LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Garfield, WAThe pilot's improper flare and recovery from a bounced landing. Factors include approach airspeed not maintained, a lack of total experience, and a ditch near the runway.Aug 22, 1993 · N22369 · Substantial damageNTSB SEA93LA182Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Ilwaco, WAThe pilot's inadequate pre-flight planning, and his attempt to take off with the aircraft over gross weight.Aug 22, 1993 · N8267P · Substantial damageNTSB NYC93LA171Accident · No injuriesLimited investigationFinal reportCessna 172 · Phillips, METhe pilot's inadequate preflight and inflight decision which resulted in fuel exhaustion and the loss of engine power.Aug 22, 1993 · N90441 · Substantial damageNTSB NYC93LA170Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Skaneateles, NYThe improper installation of the engine oil filter, and the subsequent loss of oil and engine power, resulting in forced landing and collsion with trees.Aug 22, 1993 · N20128 · Substantial damageNTSB NYC93LA167Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Slattington, PAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the proper touchdown point was not obtained.Aug 22, 1993 · N23PM · Substantial damageNTSB NYC93FA169Accident · 2 fatalField investigationFinal reportBeech F35 · Medford, NJThe pilot's failure to select a fuel tank that contained fuel, and perform the emergency procedure to restart the engine, which resulted in fuel starvation and the loss of engine power. Factors are the pilot's lack of total experience and his inadequate…Aug 22, 1993 · N3804B · Substantial damageNTSB NYC93FA166Accident · 1 fatalField investigationFinal reportPiper PA-25-260 · Plymouth, MAwas the failure of the pilot to attain proper alignment for the banner pickup which resulted in picking up the banner tow rope on the wing, and an inflight loss of control and uncontrolled contact with the ground.Aug 22, 1993 · N4844Y · Substantial damageNTSB CHI93LA347Accident · 1 fatalLimited investigationFinal reportWells Pitts S-2-S · Bloomington, ILthe pilot in command continued the aerobatic maneuver too long to effect a safe level off.Aug 22, 1993 · N10T · DestroyedNTSB CHI93LA336Accident · No injuriesLimited investigationFinal reportCessna 172M · Adrian, MIan excessive taxi speed used by the pilot-in-command. A factor related to the accident was loose gravel on the ramp and inadequate airport maintenance by the airport personnel.Aug 22, 1993 · N13923 · Substantial damageNTSB CHI93LA335Accident · No injuriesLimited investigationFinal reportCessna 150J · Rochester, INthe commercial pilot's inadequate preflight planning/preparation.Aug 22, 1993 · N74GT · Substantial damageNTSB CHI93LA334Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Hinckley, ILthe failure of the cockpit canopy.Aug 22, 1993 · N422BG · Substantial damageNTSB CHI93LA332Accident · No injuriesLimited investigationFinal reportCessna 172M · Lincoln, NEthe pilot's failure to attain the proper touchdown point.Aug 22, 1993 · N80476 · Substantial damageNTSB CHI93LA331Accident · No injuriesLimited investigationFinal reportBeech 23 · Milwaukee, WIthe student pilot's improper recovery from a bounced landing.Aug 22, 1993 · N9772L · Substantial damageNTSB CHI93DEM02Accident · Minor injuriesFinal reportSheats FALCON-XP · Zeeland, MIan inadequate maintenance inspection by the pilot/owner and the separation of the wing skin.Aug 22, 1993 · N534AA · Substantial damageNTSB ANC93LA162Accident · No injuriesLimited investigationFinal reportCessna 172 · Knik Glacier, AKThe pilot's improper inflight planning/decision, and his failure to attain the proper touchdown point. Factors were the rain and the rough/uneven terrain.Aug 22, 1993 · N3817S · Substantial damageNTSB SEA93LA202Accident · Serious injuriesLimited investigationFinal reportKope Zenith CH200 · Waterville, WAA short in the electrical wiring to the fuel pump.Aug 21, 1993 · N456K · Substantial damageNTSB SEA93LA180Accident · No injuriesLimited investigationFinal reportBeech C23 · Lakeview, ORA fractured exhaust valve. The rough terrain was a factor.Aug 21, 1993 · N6547R · Substantial damageNTSB SEA93FA179Accident · 1 fatalField investigationFinal reportCessna 172N · Lake Fork, IDPoor judgment of the pilot by flying while under the influence of alcohol and a drug, his continued flight into an area of adverse weather, and his failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors related to the accident…Aug 21, 1993 · N75644 · Destroyed