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 ANC94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot-in-command's failure to compensate for the wind conditions. The gusty wind was a factor.NTSB SEA94LA009Accident · No injuriesLimited investigationFinal reportCessna 150E · Sandy, ORFailure of the pilot to maintain proper runway alignment during the landing. The lack of adequate runway alignment marking was a related factor.NTSB SEA94LA008Accident · No injuriesLimited investigationFinal reportCessna 172RG · Corvallis, ORThe cfi's inadequate in-flight planning, and his inadvertent gear-up landing. Factors include the cfi's diverted attention.NTSB FTW94LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180C · Albuquerque, NMThe pilot's failure to maintain adequate airspeed. The high density altitude was a factor.NTSB CHI94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Frankfort, MIthe pilot's failure to perform refueling.NTSB ATL94LA003Accident · No injuriesLimited investigationFinal reportCessna T188C · Rogersville, ALWas the pilot's inadequate pre-flight preparation which resulted in fuel exhaustion during take off.NTSB ATL94LA002Accident · No injuriesLimited investigationFinal reportHughes 269B · Linville, NCThe pilot's failure to maintain airspeed that would have avoided a loss of tail rotor effectiveness (lte), and his improper compensation for tailwind condition. A factor was the lack of information in the pilot's operating handbook regarding the conditions…NTSB ANC94LA012Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Haines, AKFatigue failure in a weld on the right main landing gear oleo strut tubing.NTSB ANC94LA003Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Kenney Lake, AKThe pilot's intentional VFR takeoff into instrument meteorological conditions which resulted in spatial disorientation and a loss of control. Factors in the accident were the weather and low light conditions.NTSB SEA94LA006Accident · No injuriesLimited investigationFinal reportCessna 177A · La Sal, UTThe pilot in command's failure to abort the takeoff. Factors contributing to the accident were the high (10,000 foot) density altitude and the fence.NTSB SEA94LA005Accident · No injuriesLimited investigationFinal reportCessna T182RG · Casper, WYInadequate maintenance and inspection of the hydraulic line resulting in a loss of hydraulic pressure.NTSB NYC94LA002Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Madisonville, KYthe pilot's inadequate preflight preparation and his inadequate visual lookout in flight which resulted in the collision with wires.NTSB NYC94LA001Accident · No injuriesLimited investigationFinal reportCessna 172M · Wellsville, NYThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain.NTSB FTW94LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally RX7 · Albuquerque, NMPilot's failure to maintain aircraft control. A factor was the gusty winds.NTSB CHI94LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Benton, KSThe failure of the student pilot to maintain directional control and proper runway alignment during the landing roll. The proximity of the ditch to the runway was a related factor.NTSB ATL94IA001Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLFailure of the captain to use the proper rotation and lift-off speeds, which resulted in over rotation of the aircraft during takeoff and a subsequent tail scrape.NTSB ANC94LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot-in-command's improper preflight planning/preparation. A factor was rising terrain.NTSB ANC94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Bear Creek, AKThe pilot's delayed go-around procedure. A factor in the accident was the improper use of carburetor heat during the go-around.NTSB ANC94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKThe Pilot's improper preflight procedures in that the frost removal was not adequately performed resulting in aerodynamic stall of flight surfaces on takeoff.NTSB SEA94LA007Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Shoshoni, WYFuel exhaustion and the pilot in command's failure to refuel the aircraft.NTSB SEA94LA003Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Denton, MTThe pilot in command's failure to maintain adequate clearance with terrain. Factors contributing to the accident were unfavorable winds and the pilot in command's inadquate compensation (premature crosswind turn) for the wind conditions.NTSB SEA94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orting, WAThe pilot in command's failure to maintain aircraft control.NTSB SEA94FA004Accident · 1 fatalField investigationFinal reportCessna 182P · Heber City, UTThe pilot's improper inflight decisions and failure to maintain proper altitude. Factors include the box canyon.NTSB NYC94LA005Accident · No injuriesLimited investigationFinal reportSwift S-1 · Blairstown, NJThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall. A factor is wind gust and the pilot's inexperience in type aircraft.NTSB MIA94FA001Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-83 · Miami, FLThe failure of the water heater relay and the overpressure relief valve to operate properly. In addition, the design of the relief valve was inadequate in that it allowed the o-ring to migrate from its normal position preventing the valve from opening.NTSB LAX94FA005Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Kernville, CAthe pilot's inadvertent flight into a box canyon and his failure to attain a safe altitude. A factor in the accident was the pilot's lack of familiarity with the geographic area.NTSB LAX94FA004Accident · 4 fatalField investigationFinal reportCessna 177RG · Petaluma, CAVFR flight by the pilot(s) into instrument meteorological conditions (IMC), and failure to maintain a proper altitude and/or clearance from terrain, while approaching the destination airport. Factors related to the accident were: the low ceiling and terrain.NTSB FTW94LA002Accident · No injuriesLimited investigationFinal reportMaule M-5-200C · Watkins, COThe pilot's loss of directional control resulting in the inadvertent ground loop. A factor was the instructor's failure to take remedial action on a timely manner.NTSB FTW94LA001Accident · Minor injuriesLimited investigationFinal reportCessna T188C · New Deal, TXFailure of the pilot to maintain ground clearance while avoiding a powerline. Failure of the pilot to see a second set of power lines prior to initiating the spraying run was also a cause.NTSB CHI94LA016Accident · No injuriesLimited investigationFinal reportCessna 150J · Grosse Ile, MIThe pilot misjudged altitude/clearance during the banner pickup, which resulted in the tow rope snagging the landing gear, and failed to maintain adequate airspeed, while landing with the banner attached, which resulted in a failure (or inability) to attain a…NTSB CHI94LA005Accident · No injuriesLimited investigationFinal reportCessna 150G · Osceola, MOFracture of the number four piston at the piston pin boss. A factor related to the accident was: the lack of suitable terrain for an emergency landing.NTSB CHI94LA003Accident · No injuriesLimited investigationFinal reportWelch OW8M · Greenfield, INThe pilot's failure to properly flare the airplane. The gusty crosswind was a factor.NTSB ANC94LA005Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pilot Point, AKThe Pilot-in-command's failure to compensate for the crosswind during taxi. The crosswind was a factor.NTSB NYC94LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt. Gilead, OHthe pilot's improper inflight decision to conduct a night landing at an airport without runway lights, and the subsequent misalignment with the runway and collision with an object.NTSB LAX94LA002Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Fallon, NVwas the pilot's failure to maintain an adequate approach path to the runway and his inadequate altitude. Contributing factors were the pilot's delayed remedial action and his lack of recent experience in the airplane.NTSB FTW94LA003Accident · No injuriesLimited investigationFinal reportCessna 208B · Dfw Airport, TXThe pilot's disregard for the issued safety advisory.NTSB CHI94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Monroe, MIThe pilot's inadequate preflight planning/preparation, when he misjudged the (inadequate) supply of fuel before takeoff, which resulted in fuel exhaustion. Soft terrain in the emergency landing area was a related factor.NTSB CHI94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cheboygan, MIInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to and inadequate supply of fuel. Factors related to the accident were: the lack of suitable terrain for a forced landing, and trees in the emergency landing area.NTSB CHI94FA002Accident · 2 fatalField investigationFinal reportBeech 95 · Roodhouse, ILwas the inadequate supervision by the flight instructor which resulted in the inadvertent stall/spin by the student.NTSB CHI94FA001Accident · 1 fatalField investigationFinal reportBeech G35 · Webster, WIIn-flight breakup of the airplane for an undetermined reason.NTSB ANC94FA001Accident · 1 fatalField investigationFinal reportMaule M-6-235 · Merrill Pass, AKThe pilot-in-command's attempt to fly VFR into IMC conditions. A factor was the whiteout weather condition.NTSB SEA94LA001Accident · No injuriesLimited investigationFinal reportBeech A35 · Heber City, UTFuel starvation brought on by the absence of the roll pin which engages the fuel selector handle to the fuel selector valve shaft, and the pilot in command's misjudging his flare resulting in a hard landing.NTSB SEA93LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tooele, UTThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the fence.NTSB SEA93FA214Accident · 3 fatalField investigationFinal reportCessna 172N · Ellensburg, WAThe pilot's failure to maintain an airspeed above stalling speed (vs), and his inadequate remedial action. Factors include the pilot's diverted attention, and an inadvertent stall/spin.NTSB LAX94LA003Accident · 1 fatalLimited investigationFinal reportCessna 182H · Clear Lake Res, CAFailure of the pilot to maintain altitude, while performing a low-altitude maneuver (turn) over water. Factors related to the accident were: sun glare, haze, glassy condition of the water, and the lack of visual cues (visual perception) for the pilot to judge…NTSB LAX94LA001Accident · No injuriesLimited investigationFinal reportCessna O-2A · Tucson, AZwas the partial loss of engine power during initial climb due to partial clogging of the engine's fuel injectors. Blockage of the fuel injectors was due to inadequate maintenance of the fuel system by contract maintenance personnel.NTSB FTW94LA033Accident · Serious injuriesLimited investigationFinal reportBell 204-B · Cedar Crest, NMFailure of ground personnel to follow published procedures. A factor was the the load jettison.NTSB BFO93LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Batavia, OHThe pilot's improper flare.NTSB MIA93FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 152 · FLundetermined.NTSB LAX93LA373Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lompoc, CAwas fuel starvation. A factor in the accident was the mechanic's inadequate inspection of the airplane.