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 LAX95LA211Accident · 1 fatalLimited investigationFinal reportHarmon Dolphin · Paso Robles, CAThe pilot's decision continue VFR flight into instrument meteorological conditions (IMC), loss of aircraft control due to spatial disorientation, and exceeding the design stress limits of the airplane. The weather condition was a related factor.NTSB LAX95FA210Accident · 1 fatalField investigationFinal reportCessna P210N · Mammoth Lakes, CAthe pilot's continued flight into instrument meteorological conditions during dark nighttime over mountainous terrain; and his failure to maintain an adequate altitude to ensure terrain clearance. Thw weather and terrain were factors.NTSB FTW95LA254Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cash, ARThe loss of engine power for undetermined reasons. Factors were the low altitude at which the power loss occurred and the lack of suitable terrain for a forced landing.NTSB FTW95LA249Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Fort Stockton, TXThe fuel exhaustion induced power loss due to the pilot becoming lost/disoriented. The lack of suitable terrain for the forced landing and the weather conditions were factors.NTSB CHI95LA192Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Peru, ILthe pilot's failure to maintain directional control of the airplane while landing. A factor in the accident was the runway light.NTSB CHI95LA185Accident · Serious injuriesLimited investigationFinal reportChristen Industries S-2B · Elgin, ILthe pilot's incapacitation due to alcohol and drugs which led to a loss of consciousness.NTSB CHI95LA184Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Neligh, NEthe pilot's selection of the wrong runway for takeoff, and his failure to compensate for the tailwind. A factor was the tailwind.NTSB ATL95LA112Accident · Minor injuriesLimited investigationFinal reportGrumman AA1C · Mocksville, NCThe pilot's improper short field takeoff procedure which resulted in the inadvertent stall/mush during the takeoff.NTSB SEA95LA122Accident · No injuriesLimited investigationFinal reportCessna 177B · Seattle, WAThe pilot's inadequate remedial action when he encountered porpoising after landing on the nosewheel.NTSB FTW95LA248Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M18 · Cherry Valley, ARFuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA247Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Guymon, OKThe pilot's failure to maintain airspeed. The high density altitude was a factor.NTSB SEA95LA119Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Helena, MTThe loss of engine power for undetermined reasons.NTSB FTW95LA246Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Jennings, LAThe partial power loss for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB BFO95FA064Accident · 3 fatalField investigationFinal reportPiper PA-31P-350 · Cedar Bluff, VAthe pilot's improper planning/decision, and his allowing the airplane to exceed its maximum design/stress limitation. Factors relating to the accident were: the adverse weather conditions, and the pilot's continued flight into adverse weather.NTSB ATL95LA111Accident · No injuriesLimited investigationFinal reportCessna 188D · Athens, ALThe pilot's inadequate lookout, and his failure to maintain clearance from the utility line.NTSB ATL95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Huntsville, ALThe downdraft weather condition, and the pilot's failure to maintain adequate clearance from the terrain during his maneuver.NTSB ANC95LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Gulkana, AKThe pilot's failure to maintain directional control during the landing roll.NTSB SEA95LA118Accident · No injuriesLimited investigationFinal reportEnstrom 280C · The Dalles, ORA partial loss of engine power due to one set of ignition points becoming loose during flight. Factors included the low altitude flight and maneuvering required to conduct the operation and the resulting lack of suitable terrain for a forced landing.NTSB FTW95LA244Accident · 1 fatalLimited investigationFinal reportWalter W. Bell Lazer Edge · El Reno, OKThe pilot's failure to maintain control resulting in an inadvertent stall/spin. Factors were the pilot's performance of aerobatic maneuvers at the low altitude.NTSB FTW95LA240Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Iowa, LAThe failure of the right brake due to the hydraulic fluid leaking. Factors were proper alignment not possible and the close proximity of the ditch.NTSB CHI95LA180Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lowell, MIthe pilot's failure to obtain/maintain altitude/clearance.NTSB CHI95FA182Accident · 2 fatalField investigationFinal reportGrumman G-21E · West Chicago, ILThe pilot allowed excessive nose-up rotation of the airplane during lift-off, and failed to obtain and/or maintain adequate airspeed, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's…NTSB ATL95LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Brownsville, TNThe pilot's improper in-flight decision to land on the wet, sod runway, and his failure to use all of the available runway for landing.NTSB FTW95LA242Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Fort Stockton, TXThe pilot's improper positioning of the fuel selector to a tank with unusable fuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA241Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Denver City, TXThe loss of engine power due to a fracture of the #3 cylinder resulting in the total failure of the cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95LA179Accident · No injuriesLimited investigationFinal reportCessna T210M · Downers Grove, ILthe pilot's failure to attain the proper touchdown point, and his subsequent failure to execute a go-around.NTSB CHI95LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bay City, MIFailure of the pilot to maintain clearance from obstacles and his intentional buzzing.NTSB ATL95LA109Accident · No injuriesLimited investigationFinal reportCessna 188 · Red Springs, NCInadequate maintenance that overlooked corrosion of the exhaust manifold, which resulted in an exhaust manifold leak, an in flight fire, and a complete loss of engine power.NTSB ATL95LA108Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Garfield, GAThe pilot's failure to maintain flying speed during a climbout from a swath run which resulted in a stall and the subsequent collision with trees.NTSB NYC95LA132Accident · No injuriesLimited investigationFinal reportBeech 33 · Franklin Twp, PAThe pilot's improper planning/decision, his continued flight into adverse weather conditions, and his delay in reversing course (diverting to a new destination). The adverse weather with thunderstorms was a related factor.NTSB LAX95LA208Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe pilot's improper recovery from a bounced landing. His misjudgment of the height above the runway during flare was a factor.NTSB FTW95FA238Accident · 1 fatalField investigationFinal reportSmith LONG-EZ · Cloudcroft, NMThe pilot's failure to maintain clearance from trees. Factors were the pilot exceeded the allowable maximum gross weight of the airplane, the rising terrain, and high density altitude.NTSB ANC95LA077Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuntutuliak, AKThe airport maintenance personnel's inadequate maintenance of the runway by not replacing the yellow cones that marked the soft area. The soft area on the runway was a related factor.NTSB ANC95LA075Accident · Minor injuriesLimited investigationFinal reportHughes 500D · Ketchikan, AKAn air leak at a 'b' nut fitting on a pneumatic pc tube to the power turbine governor. Company maintenance personnel did not detect a leak after performing maintenance on the governer and P2 air line.NTSB SEA95LA117Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Challis, IDInadequate preflight/planning preparation. Factors to the accident were: downdraft and tailwind.NTSB MIA95LA149Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Miami, FLTotal blockage of the air induction at the servo fuel injector by paper from an undetermined source and inadequate maintenance servicing by other maintenance personnel. Contributing to the accident was unsuitable terrain encountered by the pilot during the…NTSB LAX95LA207Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Fall River Mill, CAFatigue failure of the No. 2 lower connecting rod bolt as a result of improper torque during the last engine overhaul.NTSB LAX95LA206Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Lebec, CAFuel exhaustion due to the pilot's lack of familiarity with the airplane's fuel sysytem and his failure to maintain an adequate supply of fuel to complete the flight.NTSB FTW95LA235Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Weatherford, TXThe pilot's failure to maintain control during landing resulting in the tail rotor blades striking the ground and separating, and the subsequent loss of directional (anti-torque) control. A factor was the uphill terrain.NTSB FTW95IA243Incident · No injuriesIncident investigationFinal reportCessna 150L · Levelland, TXThe failure of the pilot of the other aircraft to maintain clearance during a formation flight. A factor was the lack of experience in the type of operation.NTSB CHI95LA198Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Hoxie, KSthe loss of engine power due to the loose nut on the adjustment screw and the jammed exhaust valve on the number three cylinder. A factor in the accident was the ditch.NTSB BFO95LA063Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Ft Washington, MDA loss of engine power for an undetermined reason(s).NTSB BFO95LA062Accident · 1 fatalLimited investigationFinal reportBerg Steen Skybolt · Bath, NYthe pilot's failure to maintain sufficient altitude/clearance to avoid trees while performing aerobatic maneuvers. Related factors are the low altitude at which the maneuver was initiated and the delayed recovery/pull-up.NTSB BFO95LA061Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee BT-13B · Oxford, CTthe pilot's failure to maintain sufficient altitude/clearance from terrain. The low ceiling was a related factor in the accident.NTSB ANC95LA074Accident · Serious injuriesLimited investigationFinal reportChampion 11BC-S · Anchorage, AKThe pilot's improper compensation for the wind conditions. Factors associated with the accident are gusty winds and associated downdrafts.NTSB ANC95LA071Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to refuel the airplane, and his improper remedial action(s) which lead to fuel starvation.NTSB ANC95LA069Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Tyonek, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident is the rough and uneven sandbar.NTSB MIA95WA150Accident · No injuriesForeign investigationMaule M-7-235 · Cat Cay, BahamasNTSB MIA95LA168Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK 6C · Arcadia, FLInadequate preflight of the helicopter by the pilot-in-command by failure to assure adequate fuel for the flight. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB LAX95LA323Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Bear, CAthe pilot's failure to maintain directional control during an aborted takeoff attempt, which was necessitated by his failure to properly lean the fuel mixture. The pilot's limited experience in small piston engine airplanes was a factor in the accident.