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 NYC90FHD01Accident · 1 fatalFinal reportMason Hummel Bird · Lumberton, NJFailure of the rudder attach bolt, which resulted in a loss of aircraft control and an uncontrolled descent to the ground.Jun 10, 1990 · N51L · DestroyedNTSB MKC90LA125Accident · No injuriesLimited investigationFinal reportCessna 205 · Jonesburg, MOThe pilot in commands failure to attain a touchdown on the runway resulting in touchdown to the side of the runway and a nose over in soft terrain.Jun 10, 1990 · N8469Z · Substantial damageNTSB MKC90LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Winfield, IAThe pilot's decision to go-around was delayed and clearance of the power lines was not attained.Jun 10, 1990 · N73566 · Substantial damageNTSB LAX90LA217Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot failed maintain directional control by his failure to compensate for the existing wind conditions.Jun 10, 1990 · N2672D · Substantial damageNTSB LAX90FA213Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Havasu Landing, CAFailure of the pilot to properly secure an oil supply line b-nut fitting after an oil change, which allowed the oil line to become disconnected and led to oil exhaustion and subsequent engine failure. A factor related to the accident was: unsuitable terrain…Jun 10, 1990 · N3AH · DestroyedNTSB FTW90DRD12Accident · Minor injuriesFinal reportGrumman G-164A · Bastrop, LAThe pilot's improper engine procedures during ground operations and prior to takeoff which resulted in fouled spark plugs.Jun 10, 1990 · N6572 · DestroyedNTSB FTW90DPA05Accident · 1 fatalFinal reportGyroflug SC01B160 · Mineral Wells, TXTotal propeller blade retention failure, the resultant separation of one propeller blade, and the improper installation of the propeller by unknown maintenance personnel.Jun 10, 1990 · N3412L · DestroyedNTSB CHI90LA151Accident · No injuriesLimited investigationFinal reportCessna T210N · Wheeling, ILPilot-in-command's failure to obtain a proper flare attitude in the aircraft prior to touchdown.Jun 10, 1990 · N7134J · Substantial damageNTSB SEA90FA171Accident · 3 fatalField investigationFinal reportLake LA-4 · Onalaska, WAImproper in-flight planning/decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather and terrain conditions.Jun 9, 1990 · N68DG · DestroyedNTSB MKC90LA122Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Salina, KSInadvertent flight from VFR into IMC by the pilot in command.Jun 9, 1990 · N50820 · Substantial damageNTSB MKC90LA121Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Deer River, MNAirspeed not maintained and stall/spin encountered by the pilot in command.Jun 9, 1990 · N83555 · DestroyedNTSB LAX90LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · Redding, CAThe failure of the pilot in command to maintain direction control. Factors in the accident were the pilot in command's premature rotation during the takeoff and the failure to take the necessary remedial action.Jun 9, 1990 · N216PB · Substantial damageNTSB LAX90LA212Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS-3A · Vacaville, CAThe pilot's inflight loss of control for undetermined reasons.Jun 9, 1990 · N116TD · DestroyedNTSB DEN90LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Andover, SDThe pilot's failure to maintain proper clearance during the swath run.Jun 9, 1990 · N7136Z · DestroyedNTSB DEN90LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Condon, MTThe pilot's failure to abort the takeoff.Jun 9, 1990 · N8961G · DestroyedNTSB CHI90LA152Accident · No injuriesLimited investigationFinal reportBeech T-34A · Champaign, ILThe pilot's inadequate compensation for wind conditions, and his failure to adequately flare the aircraft for landing. The adverse wind was a related factor.Jun 9, 1990 · N54RF · Substantial damageNTSB CHI90DEV06Accident · Minor injuriesFinal reportCessna 210 · Salem, ILImproper positioning of the fuel selector by the pilot, which resulted in fuel starvation, and the pilot's improper emergency procedure.Jun 9, 1990 · N191A · Substantial damageNTSB BFO90LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Farmington, MDStudent pilot's misjudged approach to landing and the instructor's inadequate supervision.Jun 9, 1990 · N3456K · Substantial damageNTSB ANC90LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Circle Hot Spgs, AKThe pilot's continued flight into adverse weather conditions. The weather, and surrounding terrain, were factors.Jun 9, 1990 · N628FL · DestroyedNTSB ANC90FA086Accident · 1 fatalField investigationFinal reportPiper PA-32 · Bethel, AKThe pilot's failure to maintain airspeed during an emergency landing following an engine power loss. The loss of engine power was due to an improper fuel selector position which resulted in fuel starvation. A contributing factor was the pilot's decision to…Jun 9, 1990 · N4257T · Substantial damageNTSB SEA90LA093Accident · No injuriesLimited investigationFinal reportCessna TU206G · Elk City, IDThe pilot did not maintain directional control of the airplane during the landing roll. The landing was made on a wet runway with excessive airspeed.Jun 8, 1990 · N9922Z · Substantial damageNTSB SEA90FA098Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Susanville, CAAn improper inflight decision on the part of the pilot when he misjudged the aircraft's climb in close proximity to rising terrain.Jun 8, 1990 · N47472 · DestroyedNTSB NYC90LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJThe accident was a inflight collision with an vehicle while the airplane was on final approach for a landing.Jun 8, 1990 · N4755P · Substantial damageNTSB LAX90LA214Accident · No injuriesLimited investigationFinal reportBeech 77 · Taft, CAThe pilot's improper remedial action. Related to this accident was the pilot's inadvertent encounter with unfavorable winds.Jun 8, 1990 · N6629D · Substantial damageNTSB LAX90FA211Accident · 1 fatalField investigationFinal reportBeech 35-33 · Paso Robles, CAUndetermined.Jun 8, 1990 · N996T · DestroyedNTSB LAX90DVA04Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Buttonwillow, CAFailure of the #7 cylinder due to a pre-existing crack. The terrain condition was a related factor.Jun 8, 1990 · N6725K · DestroyedNTSB FTW90LA117Accident · No injuriesLimited investigationFinal reportBoeing E75 · Watonga, OKPic's failure to use all of the available runway. A factor was the high density altitude.Jun 8, 1990 · N55292 · Substantial damageNTSB FTW90LA116Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Pasendena, TXEngine failure due to an undetermined reason.Jun 8, 1990 · N5472Y · Substantial damageNTSB FTW90DPJ08Accident · 1 fatalFinal reportDe Havilland Venom 112 MK4 · Muskogee, OKThe pilot's premature rotation and the subsequent stall. A factor was the pilot's lack of experience in the airplane.Jun 8, 1990 · N902DM · DestroyedNTSB DEN90LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Las Cruces, NMThe fuel exhaustion induced power loss. Factors were the failure of the pilot to refuel and the high vegetation in which the forced landing was performed.Jun 8, 1990 · N50788 · Substantial damageNTSB DEN90LA128Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wahpeton, NDInadequate compensation for the wind conditions by the pilot. A factor was a strong cross wind, with gusts.Jun 8, 1990 · N32922 · Substantial damageNTSB ATL90LA127Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greenwood, SCThe pilot's failure to maintain flying speed during the flare phase of the approach/landing. Contributing to the accident was a sudden increase in winds.Jun 8, 1990 · N6285G · Substantial damageNTSB ATL90IA126Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Atlanta, GAInadequate maintenance inspection by operator personnel which resulted in operation of the tire while under-inflated.Jun 8, 1990 · N8943E · Minor damageNTSB SEA90LA116Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Camas, WAThe failure of a sprag clutch in the rotor-drive mechanism, at an altitude and position that precluded or limited the possibility of a successful outcome.Jun 7, 1990 · N51729 · Substantial damageNTSB LAX90LA210Accident · No injuriesLimited investigationFinal reportHughes 269B · Paso Robles, CAThis accident was dynamic rollover due to the terrain slope exceeding the capability of the helicopter.Jun 7, 1990 · N691RR · Substantial damageNTSB LAX90LA158Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Phoenix, AZThe pilot failed to maintain control of the airplane.Jun 7, 1990 · N50353 · DestroyedNTSB LAX90FA209Accident · Serious injuriesField investigationFinal reportCessna 208A · Fresno, CAA loss of engine oil pressure due to improper maintenance performed on the engine oil filler cap by an unknown person. In addition, the pilot misjudged his landing approach to the runway during the forced landing which resulted in an overshoot and collision…Jun 7, 1990 · N803FE · DestroyedNTSB DEN90LA127Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Sisseton, SDA total loss of power due to fuel starvation. Fuel starvation was caused by a missing fuel valve support clamp and a resultant cracked fuel line. Inadequate maintenance inspections and rough, uneven terrain were contributing factors.Jun 7, 1990 · N5649X · Substantial damageNTSB DEN90LA126Accident · No injuriesLimited investigationFinal reportCessna 172 · Boulder, COThe pilot's failure to touch down at the proper point, his misjudgment of the distance required for takeoff following the touch and go, and his delayed decision to abort the takeoff.Jun 7, 1990 · N2723E · Substantial damageNTSB CHI90LA154Accident · No injuriesLimited investigationFinal reportCessna 207 · Toledo, OHThe pilot-in-command's poor preflight planning and his failure to attain proper climb rate during initial climb after takeoff.Jun 7, 1990 · N73067 · Substantial damageNTSB ATL90LA131Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7CCM · Albany, GAFailure of the pilot in command to directional control on takeoff initial climb, and failure to maintain a visual lookout for obstacles.Jun 7, 1990 · N75064 · Substantial damageNTSB ANC90LA084Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot failed to maintain directional control during the landing roll. The crosswind was a contributing factor.Jun 7, 1990 · N1334D · Substantial damageNTSB SEA90LA097Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Cottonwood, IDThe loss of engine power due to undetermined reasons. The berm, which the airplane struck during landing, was a factor in the accident.Jun 6, 1990 · N5620X · DestroyedNTSB LAX90LA215Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Marble Canyon, AZInadequate compensation for wind conditions by the pilot and his delay in attempting a go-around. Factors related to the accident were: the surrounding terrain, unfavorable weather conditions, the pilot's failure to attain the proper touchdown point, and…Jun 6, 1990 · N732KD · Substantial damageNTSB FTW90LA115Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandeleur Isld, LAMinimum airspeed required for flight (vs) was not maintained. Contributing factors were the pilot's fatigued condition, and premature lift off.Jun 6, 1990 · N1071S · Substantial damageNTSB SEA90LA096Accident · No injuriesLimited investigationFinal reportCessna 310B · Albany, ORThe pilot's failure to extend the landing gear before landing, when he became distracted by a change in his normal routine.Jun 5, 1990 · N6647B · Substantial damageNTSB SEA90LA094Accident · No injuriesLimited investigationFinal reportCessna A150M · Seattle, WAThe fuel starvation caused by carburetor contaminants blocking the accelerator pump inlet check valve assembly and main nozzle assembly.Jun 5, 1990 · N8175V · Substantial damageNTSB NYC90LA125Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Brookville, PAWorn tail rotor pitch control assembly, due to improper maintenance/installation, and subsequent fatigue failure of the tail rotor swashplate.Jun 5, 1990 · N8315F · DestroyedNTSB MKC90LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Milford, IAFuel exhaustion due to misjudged fuel consumption calculations by the pilot in command, and a forced landing to a field with a hidden obstruction.Jun 5, 1990 · N94615 · Substantial damageNTSB MIA90LA139Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Caribbean SeaUndeterminedJun 5, 1990 · N7202F · Destroyed