NTSB investigations, 2005
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 2005 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 WHERE year(c."eventDate") = 2005 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 CHI05CA236Accident · No injuriesData collectionFinal reportYamokoski Glastar · Marcellus, MIThe in-flight loss of engine power during cruise for undetermined reasons and the unsuitable terrain the pilot encountered during the forced landing. A factor was the tall corn he encountered.NTSB ATL05LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Colquitt, GAThe pilot's failure to maintain visual lookout and clearance from obstacles while maneuvering at low altitude, which resulted in an in-flight collision with a tree and subsequent uncontrolled descent into the ground.NTSB ANC05LA125Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Skwentna, AKThe pilot's misjudged distance/altitude on final approach, which resulted in a noseover following an undershoot and in-flight collision with rough/uneven terrain. A factor associated with the accident was the rough/uneven terrain.NTSB SEA05WA178Accident · 2 fatalForeign investigationVans RV-6 · Nadrybie Dwor, PolandNTSB SEA05LA177Accident · Serious injuriesLimited investigationFinal reportTichacek N-3 Pup · Mead, WAThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB SEA05LA176Accident · Minor injuriesLimited investigationFinal reportAlon A-2A · Helena, MTThe loss of engine power for undetermined reasons, which resulted in a forced landing and nose over. A factor contributing to the accident was the ground bordering the runway pavement.NTSB SEA05CA175Accident · No injuriesData collectionFinal reportCessna 150J · Roseburg, ORThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning and failure to refuel the airplane. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA05FA152Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Freeport, FLThe failure of the pilot to maintain airspeed resulting in inadvertent stall, uncontrolled descent, and in-flight collision with terrain.NTSB MIA05CA151Accident · No injuriesData collectionFinal reportCessna 177B · Olive Branch, MSThe failure of the pilot to maintain directional control during the landing roll resulting in an on ground collision with a runway light and subsequent collapse of the nose landing gear.NTSB LAX05LA273Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Palos Verdes, CAa loss of engine power due to the cyclic fatigue failure and separation of the number 4 piston.NTSB LAX05LA272Accident · 1 fatalLimited investigationFinal reportPatch Dan F Varieze · San Diego, CAa divergence from the final approach course and an in-flight collision with storage containers for undetermined reasons.NTSB DFW05CA218Accident · No injuriesData collectionFinal reportCessna 152 · Bridgeport, TXThe pilot's inadequate compensation for wind conditions, and the flight instructor's delayed remedial action during a crosswind landing resulting in a loss of directional control.NTSB CHI05LA238Accident · No injuriesLimited investigationFinal reportBoeing 757-33N · Chicago, ILThe flightcrew's failure to maintain clearance from a fence while taxiing.NTSB CHI05CA241Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Brodhead, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.NTSB CHI05CA240Accident · No injuriesData collectionFinal reportPiper PA-12 · Boscobel, WIThe separation of the right main landing gear attachment bracket bolt during the landing and the pilot's aircraft control not possible with the collapsed gear.NTSB CHI05CA239Accident · No injuriesData collectionFinal reportBeech 36 · Holland, MIThe failure of the pilot to extend the landing gear prior to landing. A factor to the accident was the pilot becoming distracted by his passengers during landing.NTSB ATL05CA150Accident · No injuriesData collectionFinal reportMaule M4-210C · OCRACOKE iSLAND, NCThe pilot's inadequate compensation for winds and his failure to maintain directional control during a crosswind landing, which resulted in an on-ground collision with trees. A factor was the crosswind condition.NTSB ANC05TA126Accident · No injuriesFinal reportPiper PA-18-150 · Cold Foot, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing down during the landing roll. A factor associated with the accident was the rough and uneven terrain.NTSB ANC05CA124Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Chickaloon, AKThe pilot's misjudged distance and altitude on final approach to land, which resulted in an undershoot and structural damage to the airplane. A factor associated with the accident was a downdraft.NTSB DFW05IA222Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Winnie, TXThe loss of engine power due to the failure of the second-stage turbine wheel as a result of low cycle fatigue.NTSB DFW05CA223Accident · Serious injuriesData collectionFinal reportAerostar International RX-8 · Denton, TXThe passenger's failure to follow landing instructions, which resulted in serious injury. A contributing factor was the high wind.NTSB DEN05FA128Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Vail, COthe pilot's improper in-flight planning and decision making and failure to maintain clearance from the terrain. Contributing factors include the pilot's attempt to takeoff from the highway, high density altitude, the downdrafts, and the sign.NTSB DCA08WA012Accident · No injuriesForeign investigationBoeing MD-82 · Jakarta, IndonesiaNTSB DCA05MA095Accident · Minor injuriesMajor investigationFinal reportBoeing 747-200 · Aganathe flight crews' failure to verify that the number of landing gear annunciations on the second officer’s panel was consistent with the number specified in the abnormal/emergency procedures checklist, which led to a landing with the nose gear retracted.NTSB LAX05FA271Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Pomona, CAA loss of engine power during the landing approach due to fuel starvation caused by debris and corrosion in the carburetor assembly. A factor contributing to the accident was the failure of the owner to comply with the manufacturer's service bulletin…NTSB IAD05LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Smoketown, PAA loss of engine power during the climb for undetermined reasons, resulting in a forced landing.NTSB DFW05FA217Accident · 2 fatalField investigationFinal reportBell 206B · Gulf of MexicoThe loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel calculations.NTSB DFW05CA213Accident · No injuriesData collectionFinal reportBell 206L · Gulf of MexicoThe pilot's failure to maintain clearance with a stationary object while landing.NTSB DEN05LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Cedar City, UTthe loss of engine power for reasons undetermined. Contributing factors include the lack of suitable terrain for a forced landing, and the soft dirt.NTSB DEN05CA129Accident · No injuriesData collectionFinal reportPiper PA-18A-135 · Cedaredge, COthe pilot's failure to maintain aircraft control, and the pilot's improper in-flight planning. Contributing to the accident was the wind shift, resultant tailwind, and the inadvertent stall.NTSB ATL05FA148Accident · 2 fatalField investigationFinal reportBeech A36 · Jamestown, TNThe pilot's decision to continue flight into an area of known thunderstorm activity, which resulted in loss of aircraft control and collision with trees and the ground during the result uncontrolled descent.NTSB ATL05FA145Accident · 1 fatalField investigationFinal reportCessna 310R · Apopka, FLThe pilot's failure to maintain adequate visual lookout and object clearance, which resulted in the in-flight collision with trees.NTSB ATL05CA147Accident · Minor injuriesData collectionFinal reportCessna 172G · Ridgeland, SCThe loss of engine power for undertermined reasons which resulted in a collision with objects.NTSB SEA05LA172Accident · 2 fatalLimited investigationFinal reportMK II Legacy Sport · Madras, ORThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall/spin and subsequent collision with the ground.NTSB SEA05CA173Accident · No injuriesData collectionFinal reportHughes 369E · Donnelly, IDThe pilot's failure to maintain clearance of a tree during a landing attempt due to loss of visibility from a self induced brown-out condition. Contributing factors were the pilot's failure to identify a hazardous landing site, and the tree.NTSB DFW05CA231Accident · No injuriesData collectionFinal reportBell 47 · Monette, ARThe loss of control as result of a loss of hydraulic pressure for undetermined reasons.NTSB DFW05CA212Accident · No injuriesData collectionFinal reportGrumman G164B · Alexandria, LAThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the high density altitude.NTSB DCA05RA093Accident · 160 fatalForeign investigationBoeing MD-82 · Machiques, VenezuelaNTSB ATL05CA146Accident · No injuriesData collectionFinal reportPiper 22 · Archdale, NCThe pilot's failure to maintain directional control during landing roll, which resulted in a nose over.NTSB DFW05CA216Accident · No injuriesData collectionFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain directional control during the take-off roll.NTSB NYC05LA134Accident · 3 fatalLimited investigationFinal reportPiper PA-28-180 · Erie, PAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion on approach, and subsequent loss of engine power.NTSB LAX05LA270Accident · Serious injuriesLimited investigationFinal reportPrescott Aeronautical Pusher · Redding, CAthe in-flight separation of the propeller for undetermined reasons.NTSB LAX05LA267Accident · No injuriesLimited investigationFinal reportBarnes Lancair Legacy · Groveland, CAThe inaccurate fuel quantity sensors and the pilot's failure to verify the fuel quantity on board prior to takeoff, which resulted in fuel exhaustion.NTSB LAX05CA268Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Reno, NVThe pilot's inadequate compensation for the crosswind gust and failure to maintain lateral and directional control during the landing flare.NTSB DFW05WA214Accident · 1 fatalForeign investigationAyres S2R · Serignan, FranceNTSB DEN05FA126Accident · 4 fatalField investigationFinal reportCessna 425 · Lone Tree, COThe pilot's failure to properly execute the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB DCA05RA092Accident · 121 fatalForeign investigationBoeing B737-300 · Grammatikos, GreeceNTSB CHI05CA252Accident · No injuriesData collectionFinal reportCessna 150E · Durand, WIThe inadequate flare during landing by the pilot. A contributing factor was the lack of certification of the pilot.NTSB ATL05FA144Accident · No injuriesField investigationFinal reportMBB BK 117 B-1 · Jacksonville, FLThe pilot in-flight decision to land in a unsuitable landing area during a precautionary landing. A factor was the loss of power on the number two engine.NTSB ATL05CA143Accident · No injuriesData collectionFinal reportCessna 402B · Alabaster, ALThe loss of engine power for undetermined reasons.