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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB LAX90LA217Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot failed maintain directional control by his failure to compensate for the existing wind conditions.NTSB 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…NTSB 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.NTSB 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.NTSB CHI90LA151Accident · No injuriesLimited investigationFinal reportCessna T210N · Wheeling, ILPilot-in-command's failure to obtain a proper flare attitude in the aircraft prior to touchdown.NTSB 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.NTSB MKC90LA122Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Salina, KSInadvertent flight from VFR into IMC by the pilot in command.NTSB MKC90LA121Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Deer River, MNAirspeed not maintained and stall/spin encountered by the pilot in command.NTSB 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.NTSB LAX90LA212Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS-3A · Vacaville, CAThe pilot's inflight loss of control for undetermined reasons.NTSB DEN90LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Andover, SDThe pilot's failure to maintain proper clearance during the swath run.NTSB DEN90LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Condon, MTThe pilot's failure to abort the takeoff.NTSB 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.NTSB 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.NTSB BFO90LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Farmington, MDStudent pilot's misjudged approach to landing and the instructor's inadequate supervision.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX90FA211Accident · 1 fatalField investigationFinal reportBeech 35-33 · Paso Robles, CAUndetermined.NTSB 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.NTSB FTW90LA117Accident · No injuriesLimited investigationFinal reportBoeing E75 · Watonga, OKPic's failure to use all of the available runway. A factor was the high density altitude.NTSB FTW90LA116Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Pasendena, TXEngine failure due to an undetermined reason.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX90LA210Accident · No injuriesLimited investigationFinal reportHughes 269B · Paso Robles, CAThis accident was dynamic rollover due to the terrain slope exceeding the capability of the helicopter.NTSB LAX90LA158Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Phoenix, AZThe pilot failed to maintain control of the airplane.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC90LA084Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot failed to maintain directional control during the landing roll. The crosswind was a contributing factor.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB MIA90LA139Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Caribbean SeaUndetermined