NTSB investigations, 2008
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2008 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") = 2008 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 CHI08WA244Accident · 2 fatalClass 5 · ForeignPiper PA-44-180 · Adriatic Sea, CroatiaOn August 1, 2008, at 1333 universal coordinated time, a Piper PA-44-180 Seminole airplane, registration D-GZXB, serial no. 4496165, crashed into the Adriatic Sea off the coast of Zadar, Croatia. The two pilots on-board were fatally injured. The instructional…NTSB CHI08CA231Accident · No injuriesData collectionFinal reportWeatherly 201B · Creston, ILThe pilot's selection of the unsuitable terrain next to the runway to avoid the landing traffic. Contributing to the accident was the hill in the middle of the runway that blocked the pilot's view of the other traffic and the high vegetation near the runway.NTSB CHI08CA229Accident · No injuriesData collectionFinal reportPrendergast RV-7A · Manchester, MIThe pilot's inadequate flare during landing. Contributing to the accident was the uneven terrain.NTSB MIA08LA152Accident · 2 fatalLimited investigationFinal reportMorris George Velocity 173RG · St. Augustine, FLA loss of control in flight due to undetermined reasons.NTSB LAX08LA251Accident · No injuriesLimited investigationFinal reportCessna TU206E · Murrieta, CAA malfunction of the flight control system and loss of engine power for undetermined reasons.NTSB LAX08CA278Accident · No injuriesData collectionFinal reportPiper PA-22 · St. Paul, ORThe pilot's misjudged altitude, speed, and subsequent failure to attain the proper touchdown point while landing.NTSB ENG08WA034AccidentForeign investigationEurocopter EC135 · Kiskunlachaza, HungaryOn July 31, 2008, at approximately 1343 local time, an OMSZ Legimento Kht Eurocopter, EC-135 T2, having registration HA-ECE crashed as it was attempting an emergency landing about 2.2 kilometers directly south of Budapest, near Kiskunlachaza Hungary. The…NTSB DFW08CA208Accident · No injuriesData collectionFinal reportGroom Sparrow Hawk · Tulsa, OKThe student pilot's failure to maintain control of the gyroplane. Contributing to the accident was the lack of recent flight instruction prior to the flight.NTSB DCA08MA085Accident · 8 fatalClass 1 · MajorFinal reportRaytheon Corporate Jets BAE 125-800A · Owatonna, MNThe captain’s decision to attempt a go-around late in the landing roll with insufficient runway remaining. Contributing to the accident were (1) the pilots’ poor crew coordination and lack of cockpit discipline; (2) fatigue, which likely impaired both pilots’…NTSB CHI08FA224Accident · 2 fatalField investigationFinal reportMoser Georg Lancair Legacy FG · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CHI08CA227Accident · No injuriesData collectionFinal reportHead Balloons AX9-118 · Cook, MNThe pilot's decision to land in a confined area. Contributing to the accident were the hidden power transmission lines and the confined landing site.NTSB CHI08CA225Accident · Serious injuriesData collectionFinal reportAero Commander 200D · Tecumseh, MIThe pilot flaring too high, and his inadvertent pilot-induced oscillation during the landing flare/touchdown. Contributing to the accident was the collapse of the nose landing gear.NTSB NYC08FA261Accident · No injuriesField investigationFinal reportEclipse EA500 · West Chester, PAThe pilot's failure to obtain the proper touchdown point, and his excessive airspeed on approach.NTSB LAX08LA283Accident · No injuriesLimited investigationFinal reportCessna 172 · Honolulu, HIThe flight's encounter with the jet wash from a parked commercial airplane while taxiing for takeoff.NTSB LAX08CA249Accident · No injuriesData collectionFinal reportFowler SX300 · Cheyenne, WYLoss of engine power due to fuel starvation.NTSB LAX08CA248Accident · No injuriesData collectionFinal reportBristol Titan Tornado II · Green River, UTThe encounter with rough terrain during an off-field precautionary landing.NTSB ENG08RA033IncidentForeign investigationBoeing 777 · Tokyo, JapanOn July 30, 2008, a Vietnam Airline B777-200, Registration VNA146, experienced an undercowl engine fire shortly after landing at Narita International Airport, Tokyo, Japan. The airport fire team responded to a report of smoke from the No. 2 engine during…NTSB CHI08FA222Accident · Minor injuriesField investigationFinal reportPiper PA-22 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed while taking off in gusting winds, which resulted in an aerodynamic stall and subsequent loss of control.NTSB SEA08CA168Accident · Minor injuriesData collectionFinal reportWSL PZL Mielec · Caldwell, IDThe pilot failed to maintain clearance from a power line while maneuvering. Contributing to the accident was a vehicle.NTSB NYC08FA260Accident · 2 fatalField investigationFinal reportPiper PA-23 · Highlands, NCThe pilot's improper decision to fly into an area of thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the air traffic controller's failure to comply with FAA directives regarding issuance of precipitation location and…NTSB DFW08CA202Accident · No injuriesData collectionFinal reportNorth American P-51D · Tulsa, OKThe pilot's failure to maintain aircraft control during takeoff.NTSB DCA08WA086AccidentForeign investigationBoeing 767 - 200 · Budapest, HungaryOn July 29, 2008, at 1607 local Budapest time, a Krasnojarsky Airlines Boeing 767-200, EI-GBA, experienced an inadvertent deployment of an emergency escape slide after takeoff from Budapest, Hungary. The flight continued to its destination of Domodedovo…NTSB CHI08LA219Accident · Serious injuriesLimited investigationFinal reportKolb Mark II · Chisholm, MNThe loss of engine power during initial climb for undetermined reasons.NTSB ANC08LA093Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKThe pilot's failure to maintain directional control during an aborted landing.NTSB ANC08IA092Incident · No injuriesIncident investigationFinal reportSaab-Scania Saab 340B · Anchorage, AKThe failure of one of the stage 1 gas generator rotor blades due to high-cycle fatigue, resulting in a contained engine failure during the takeoff roll.NTSB LAX08CA257Accident · No injuriesData collectionFinal reportCessna 150M · Phoenix, AZThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB DEN08IA130Incident · No injuriesIncident investigationFinal reportRaytheon Cobra · Colorado Springs, COThe flight team's failure to program the UAS with flight-tested parameters that could tolerate the high density altitude and tailwind conditions encounted during the flight, which resulted in two undershoot approaches, and the existence of an undiscovered…NTSB CHI08LA228Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Maple Lake, MNThe certified flight instructor's delayed remedial action to the encountered stall. Contributing to the accident was the student pilot's slow airspeed and inadvertent stall.NTSB CHI08CA218Accident · No injuriesData collectionFinal reportCessna T188C · Marion, IAThe pilot not maintaining airspeed while performing an aerial application maneuver and the inadvertent stall he encountered. Contributing to the accident was the gust of wind during the maneuver.NTSB CHI08CA217Accident · No injuriesData collectionFinal reportGrumman G-164A · Veedersburg, INThe oil filler cap not reinstalled by the pilot prior to the aerial application flight and the total loss of engine oil during an aerial application. Additional causes were the low altitude of the operation and the unsuitable terrain encountered by the pilot…NTSB ANC08CA091Accident · No injuriesData collectionFinal reportCessna T206H · King Salmon, AKThe pilot's misjudged speed and distance during a water landing.NTSB ANC08CA090Accident · No injuriesData collectionFinal reportCessna 180G · Anchorage, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was an inadvertent ground-loop.NTSB SEA08CA169Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Helena, MTThe failure of the pilot receiving instruction to adequately compensate for the crosswind condition and failure to maintain directional control. Also causal was the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB NYC08LA259Accident · Serious injuriesLimited investigationFinal reportSands Thomas E Rotorway 162 · Graysville, TNA loss of control for undetermined reasons.NTSB LAX08FA246Accident · 3 fatalField investigationFinal reportCessna 172N · McMurray, WAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.NTSB DFW08CA200Accident · No injuriesData collectionFinal reportCurtiss-Wright 12Q · Erie, COFailure of the tail wheel control cable during landing roll out, which resulted in a loss of control.NTSB CHI08LA214Accident · Minor injuriesLimited investigationFinal reportBolenbaugh Phillip William Rans S-6ES · Oshkosh, WIThe pilot's improper landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB SEA08CA167Accident · No injuriesData collectionFinal reportErcoupe 415-C · Corona, CAThe pilot's inadequate compensation for wind conditions and failure to maintain an adequate airspeed, resulting in a stall/mush. Contributing to the accident was the gusty crosswind conditions.NTSB NYC08LA258Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Atlanta, GAThe pilot's improper flare during landing.NTSB NYC08CA321Accident · No injuriesData collectionFinal reportGrimes Barry R Chinook Plus TWO · Magnolia Springs, ALThe total loss of engine power during initial climb due to the failure of the fuel pump.NTSB NYC08CA257Accident · Minor injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe flight instructor's inadequate remedial action following the student pilot's improper recovery from a bounced landing.NTSB MIA08CA150Accident · Serious injuriesData collectionFinal reportBuckeye Breeze · New Market, TNThe student pilot's failure to consider the aircraft's performance for the takeoff.NTSB LAX08CA250Accident · No injuriesData collectionFinal reportCessna 182N · Big Creek, IDThe airplane encountered a downdraft during the landing flare. Contributing to the accident was the high density altitude.NTSB DEN08LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Athens, TXA partial loss of engine power during initial climb due to undetermined reasons, which led to an uncontrolled descent and subsequent aerodynamic stall. Contributing to the accident was the pilot's improper preflight decision to attempt the flight with a…NTSB CHI08LA216Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Watertown, WIThe pilot's failure to maintain adequate airspeed during the go-around, resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed recovery from the bounced landing.NTSB CHI08LA215Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Rio Grande, NJA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB CHI08CA223Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Ambia, INThe altitude/clearance not obtained/maintained by the pilot while maneuvering over an agricultural field during an aerial application. Contributing factors were the sunglare in the direction of flight, the low altitude of the operation, and the upslope of the…NTSB CHI08CA220Accident · Minor injuriesData collectionFinal reportAir Tractor AT-401 · Lake View, IAThe pilot not obtaining/maintaining altitude/clearance from the power line while performing an aerial application maneuver.NTSB DFW08CA199Accident · No injuriesData collectionFinal reportGrumman G-164A · Newport, ARThe pilot's failure to maintain aircraft control. Contributing factors were the high temperature and tailwind.NTSB DFW08CA198Accident · No injuriesData collectionFinal reportRobinson R22 · Rosharon, TXThe pilot's failure to maintain terrain clearance while maneuvering. Contributing to the accident was the low altitude.