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 MKC90FA101Accident · 1 fatalField investigationFinal reportBeech J-35 · Pine Bluff, ARAircraft stall, from which recovery was not achieved.NTSB MIA90LA113Accident · No injuriesLimited investigationFinal reportStinson 108 · Bushnell, FLFailure of the instrucor pilot (CFI) to assure that a timely go-around was made. The obstruction (transmission line) was a related factor.NTSB LAX90TL#02Accident · No injuriesClass 3Final reportDouglas C-54B · Chico, CANTSB LAX90LA159Accident · No injuriesLimited investigationFinal reportCessna 182L · Bullhead City, AZThe pilot's preflight planning/preparation and fuel calculations were poor.NTSB FTW90DPA02Accident · No injuriesFinal reportCessna A188B · Perry, TXThe total loss of engine power as a result of water contamination of the fuel supply. A factor was the unsuitable terrain in which the pilot had to make the forced landing.NTSB NYC90FA099Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Fredericksburg, PAContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure (or inability) to maintain control of the aircraft after becoming spatially disoriented. Factors related to the accident were: adverse weather conditions, and…NTSB MKC90LA098Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Ames, IAThe wrong runway was selected and directional control was not maintained by the pilot in command.NTSB LAX90LA157Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Mammoth Lakes, CAPilot's encounter with a strong downdraft while cruising at an inadequate altitude. A contributing factor was the high altitude which limited available engine power for recovery.NTSB FTW90LA104Accident · No injuriesLimited investigationFinal reportRyan Navion A · Denison, TXPilot's attempted takeoff with conditions in excess of the airplane's performance capabilities. Contributing to the accident was the high density altitude and the uphill runway.NTSB CHI90LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lambertville, MIThe pilot's failure to maintain aircraft control during the aborted landing.NTSB CHI90DEC01Accident · 2 fatalFinal reportMoore Acroduster II SA750 · New Haven, MIThe pilot's the improper execution and/or recovery from an aerobatic maneuver (inverted flat spin), which resulted in a collision with the terrain.NTSB ATL90FA105Accident · 1 fatalField investigationFinal reportCessna 172M · Jonesboro, GAPilot-in-command's inadequate preflight and inflight planning, and his delayed climb after execution of a go-around. Contributing factors were his misreading of airfield wind information, his improper utilization of the flaps during climbout, his failure to…NTSB NYC90LA101Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Meadville, PALoss of directional control by the pilot during landing. Contributing factor was gusty wind conditions.NTSB NYC90LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Tinton Falls, NJThe failure of the student pilot to ensure there was sufficient fuel on board for the planned flight. A factor related to the accident was the failure of the flight instructor to properly prepare his student for the flight.NTSB NYC90LA096Accident · No injuriesLimited investigationFinal reportCessna 172A · Mt. Pleasant, PAThe pilot failed to maintain directional control during takeoff, a premature lift-off, and an inadvertent stall/mush. A factor in the accident was the unfavorable wind.NTSB NYC90LA094Accident · No injuriesLimited investigationFinal reportCessna C-172 · Matawan, NJPilot factor in that the pilot landed long and was unable to stop the a/c on the remaining r/w.NTSB MKC90LA097Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Little Rock, ARPilot in command's failure to refuel the airplane, which resulted in fuel exhaustion. Related to the accident was: unsuitable terrain in the emergency landing area.NTSB MIA90LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Isla Grande, PRImproper use of carburetor heat by the pilot, which resulted in carburetor ice. The weather (carburetor icing condition) was a related factor.NTSB FTW90LA103Accident · No injuriesLimited investigationFinal reportBeech BE-35M · Tomball, TXAn engine failure due to detonation and subsequent piston overtemperature and erosion. A factor related to the accident was the lack of suitable terrain.NTSB DEN90LA102Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · Montrose, COInadequate compensation for wind conditions by the pilot. The adverse wind conditions were related factors.NTSB CHI90LA120Accident · No injuriesLimited investigationFinal reportCessna 172N · Angola, INFailure of the pilot to maintain directional control of the aircraft, while landing in gusty/crosswind conditions. The adverse wind was a related factor.NTSB CHI90FA118Accident · 1 fatalField investigationFinal reportSikorsky S-58F · Southfield, MIA loss of control due to physical incapacitation for unknown reason(s).NTSB BFO90LA040Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Have De Grace, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.NTSB NYC90LA095Accident · No injuriesLimited investigationFinal reportBeech Baron 58 · Danbury, CTPilot factor in that the pilot elected to abort the takeoff with insufficient r/w remaining to stop the aircraft on the runway and collided with a fence, car & van.NTSB NYC90LA093Accident · No injuriesLimited investigationFinal reportCessna C-150 · Turbotville, PAThe pilot to maintain sufficent flying speed for takeoff when strong winds were encountered.NTSB MKC90LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lockwood, MOTouchdown point not attained and go-around not performed by the pilot in command. Contributing factors were a wet, grass runway.NTSB LAX90LA156Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Apple Valley, CAFuel contamination and the pilot's failure to maintain airspeed while maneuvering.NTSB LAX90LA155Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Corona, CAThe partial failure of the engine's right magneto, which resulted in a loss of engine power.NTSB FTW90LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Tulsa, OKAn engine failure due to a disconnect in the magneto drive train caused by the crankshaft gear not being properly installed and secured during a recent engine overhaul.NTSB FTW90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA28-235 · Granbury, TXFuel starvation due to the pilot's disregard for the position of the fuel tank selector.NTSB DEN90LA101Accident · No injuriesLimited investigationFinal reportCessna 172 · Englewood, COThe pilot landed with a tailwind, and cost control of the airplane during rollout.NTSB DEN90FA103Accident · 6 fatalField investigationFinal reportPiper PA-32C-300 · Leadville, COVFR flight into instrument meteorological conditions (IMC) by the pilot, and his failure to maintain sufficient altitude and clearance from mountainous terrain. Factors related to the accident were: the terrain and weather conditions, the pilot's…NTSB BFO90IA039Incident · No injuriesIncident investigationFinal reportBellanca 17-30 · Davis, WVThe improper installation of the connecting rod bearings on the number one cylinder.NTSB NYC90LA092Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Unionville, PAThe loss of thermal lift which necessitated a forced landing on unsuitable terrain covered by trees and high obstructions.NTSB NYC90DNA02Accident · No injuriesFinal reportBell 47G5 · Marion, MAImproper use of carburetor heat by the pilot resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.NTSB MIA90LA111Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLLoss of engine power for an unknown reason.NTSB LAX90LA154Accident · No injuriesLimited investigationFinal reportCessna 120 · Phoenix, AZThe pilot failed to maintain directional control by improperly using the rudders/tall wheel steering.NTSB FTW90FA100Accident · No injuriesField investigationFinal reportLearjet 25D · Uvalde, TXFailure of the pilot to obtain a pre-flight weather briefing, and his improper in-flight planning/decision, which resulted in an in-flight encounter with severe weather and subsequent engine flameouts. Factors related to the accident were: darkness, the…NTSB DEN90FA100Accident · 4 fatalField investigationFinal reportPiper PA31-325 · Cedar City, UTThe pilot failed to maintain a minimum safe altitude over mountainous terrain during a night VFR approach for landing.NTSB NYC90LA091Accident · No injuriesLimited investigationFinal reportCessna O337F · Brant, NYThe pilot's premature rotation and failure to obtain airspeed.NTSB MIA90LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Crystal Springs, MSPilots failure to assure that the fuel cap was in position and secured prior to departure. This resulted in fuel siphoning overboard resulting in the precautionary landing.NTSB MKC90LA096Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot in command's failure to compensate for wind while landing resulting in loss of directional control and collision with terrain.NTSB MKC90LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Allport, ARImproper use of carburetor heat by the pilot. Contributing factors were carburetor icing conditions, power lines and visual outlook inadequate by the pilot.NTSB MIA90IA109Incident · No injuriesIncident investigationFinal reportBoeing 707-321B · Miami, FLThe airplane's aft CG limit had been exceded due to improper weighing procedures.NTSB LAX90LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe student pilot inadvertently stalling the aircraft and an inadequate altitude to perform a stall recovery. Factors in this accident were: lack of total experience and student's anxiety.NTSB DEN90FA099Accident · 2 fatalField investigationFinal reportPiper PA-22-160 · Scranton, NDPilot factor in that he failed to maintain aircraft control while performing an inflight maneuver.NTSB CHI90FA117Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · West Bend, WIInflight failure of the right wing strut-to-spar attachment fitting due to fatigue initiated by improper welding techniques involving inadequate post-weld cooling control.NTSB ATL90LA103Accident · No injuriesLimited investigationFinal reportCessna 182 · Griffin, GAImproper flare by the pilot.NTSB ATL90DLQ01Accident · No injuriesFinal reportBell 47D1 · Hickman, KYImproper in-flight planning/decision by the pilot. The resultant tailwind was a related factor.NTSB MKC90LA093Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Eden Prairie, MNCollision with animal, factors in the accident were light condition, dusk, and remedial action was not possible.