NTSB investigations, 2005
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\") = 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 CHI05FA162Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Grand Rapids, MNAn observed loss of engine power due to the bound/jammed turbocharger wastegate during takeoff, the pilot not maintaining airplane control, and the stall he inadvertently encountered. A factor was the maintenance personnel not replacing the turbocharger…NTSB CHI05CA170Accident · No injuriesData collectionFinal reportMooney M20K · Kennett, MOThe fuel starvation, inadequate preflight planning and preparation, and inadequate in-flight planning/decision by the pilot.NTSB CHI05CA168Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Minneapolis, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors associated with the accident were the crosswind and the taxiway sign.NTSB CHI05CA165Accident · No injuriesData collectionFinal reportPiper PA-22-180 · Valparaiso, INThe pilot improperly flared the airplane which resulted in a hard landing and the subsequent main gear collapse.NTSB ATL05CA122Accident · Serious injuriesData collectionFinal reportAeronca C3 · Summerville, SCThe maintenance personnel failure to secure the intake valve adjustment jam nut which resulted in excessive valve clearance, and the subsequent loss of engine power.NTSB ANC05LA100Accident · No injuriesLimited investigationFinal reportPZL Warzawa-Okecie 104 Wilga 80 · Platinum, AKA loss of engine power for an undetermined reason during takeoff initial climb from a remote beach, which resulted in a ditching and subsequent nose over.NTSB ANC05CA092Accident · No injuriesData collectionFinal reportSweeney Preceptor Ultra Pup · Chitina, AKThe pilot's failure to abort the takeoff, and his premature lift-off resulting in a stall due to inadequate airspeed. The pilot's selection of unsuitable terrain for takeoff was a contributing factor.NTSB ANC05CA091Accident · No injuriesData collectionFinal reportPiper PA-20 · Nome, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in the collapse of the main landing gear, and a nose over. A factor associated with the accident was a crosswind.NTSB SEA05LA137Accident · No injuriesLimited investigationFinal reportScheibe SF-28A Tandem-Falke · North Plains, ORThe pilot's failure to maintain airspeed during landing. Inadequate emergency procedures training and high vegetation were factors.NTSB SEA05CA140Accident · No injuriesData collectionFinal reportPiper PA-22 · Kamaih, IDFuel starvation due to the pilot's improper placement of the fuel selector, resulting in a loss of engine power, and collision with terrain.NTSB MIA05FA130Accident · 1 fatalField investigationFinal reportBeech V35 · De Funiak Sprgs, FLThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and an in-flight collision with tress and terrain.NTSB LAX05LA224Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude and his decision to turn toward higher terrain.NTSB IAD05LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, NHThe student pilot's failure to maintain airspeed, and the flight instructor's inadequate remedial action, which resulted in an inadvertant stall and uncontrolled descent into terrain.NTSB IAD05LA090Accident · Serious injuriesLimited investigationFinal reportAeronca 11CC · Charlotte, VTThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall, and impact with terrain. A factor in the accident was the partial loss of engine power for undetermined reasons.NTSB ATL05LA121Accident · 1 fatalLimited investigationFinal reportDenmark Mini-Max · Covington, GAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, uncontrolled descent, and subsequent collision with the ground.NTSB ATL05CA120Accident · No injuriesData collectionFinal reportGrumman American AA-1B · Durham, NCThe pilot's failure to maintain directional control. Factors were soft and wet terrain.NTSB ANC05LA094Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Whittier, AKThe pilot's becoming lost/disoriented while maneuvering due to inadequate in-flight planning/decision making, which resulted in fuel exhaustion and a forced landing in tree-covered terrain. A factor contributing to the accident was fuel exhaustion.NTSB ANC05CA095Accident · No injuriesData collectionFinal reportCessna 207 · Bethel, AKAn in-flight collision with a bird during cruise flight, which resulted in structural damage to the airplane's wing.NTSB ANC05CA089Accident · No injuriesData collectionFinal reportCessna 207A · Excursion Inlet, AKThe pilot's failure to maintain clearance from a building during taxi from landing, which resulted in structural damage to the left wing when it struck the building.NTSB SEA05FA136Accident · 2 fatalField investigationFinal reportBeech E-55 · Lopez, WAThe pilot's failure to refuel the airplane which resulted in a dual loss of engine power during normal descent due to fuel exhaustion. A contributing factor was the incorrect installation of the left and right wing fuel sight gage/float assemblies by unknown…NTSB NYC05CA120Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Allentown, PAThe pilot's improper flare, which resulted in a hard landing.NTSB MIA05LA129Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Glen Saint Mary, FLThe separation of a plastic sleeve off the idle stop of the servo fuel injector for undetermined reasons resulting in decreased fuel flow and subsequent total loss of engine power.NTSB MIA05CA128Accident · No injuriesData collectionFinal reportCessna 152 · St. Augustine, FLThe failure of the student pilot to maintain directional control during the landing roll resulting in the on-ground encounter with wet grass and subsequent nose over.NTSB LAX05LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yuma, AZthe pilot's misjudged distance and altitude, which resulted in an undershoot and collision with a airport boundary fence short of the runway. A factor in the accident was the pilot's lack of familiarity flying the airplane at a high gross weight with a center…NTSB LAX05LA222Accident · 1 fatalLimited investigationFinal reportQuiksilver MX LII Sport · Palmdale, CAan in-flight loss of control for undetermined reasons.NTSB IAD05LA109Accident · No injuriesLimited investigationFinal reportBeech BE-35-C33A · East Hampton, NYThe pilot's failure to attain the proper touchdown point during landing, which resulted in the airplane touching down short of the landing surface.NTSB IAD05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHThe flight instructor's failure to maintain directional control during the landing rollout. A factor was the night lighting conditions.NTSB IAD05LA089Accident · 1 fatalLimited investigationFinal reportLongtin Kitfox Model III · New London, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor in the accident was the tail wind condition.NTSB CHI05LA171Accident · Serious injuriesLimited investigationFinal reportYonchak Skybolt · El Dorado, KSThe pilot's failure to maintain airspeed while maneuvering in the traffic pattern which resulted in an inadvertent stall. A factor was the low altitude.NTSB CHI05CA169Accident · Minor injuriesData collectionFinal reportKelley Volmer Amphibian B · Nauvoo, ILThe pilot's failure to maintain appropriate airspeed during landing, which resulted in a stall/mush condition and hard landing.NTSB CHI05CA167Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Palmyra, WILoss of directional control by the dual student and delayed remedial action by the flight instructor resulting in the airplane nosing over.NTSB ATL05CA124Accident · No injuriesData collectionFinal reportCessna 182P · Lanett, ALThe pilot's misjudgment of speed and distance, and his failure to do a go around. A factor was the wet runway.NTSB ANC05LA093Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Anchorage, AKThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in a loss of control and subsequent uncontrolled descent into a lake. A factor contributing to the accident was an inadvertent stall.NTSB NYC05LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Carrollton, OHThe pilot's inadequate preflight inspection that resulted in fuel contamination and a subsequent loss of engine power. A factor related to the accident was the deteriorated fuel cap seals.NTSB MIA05LA127Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLThe failure of the pilot to abort the takeoff after a reported loss of engine power during the takeoff roll, resulting in the in-flight collision with a fence and trees. A factor in the accident was the failure of the pilot to lower the flaps to 10 degrees as…NTSB MIA05LA126Accident · 1 fatalLimited investigationFinal reportJSH Air LLC II Comp Air 7SLX · Winter Haven, FLThe abrupt steep pitch-up during the initial climb for undetermined reasons resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with terrain.NTSB LAX05LA221Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Honolulu, HIthe flight crew's failure to ensure that the landing gear lever was in the full down position prior to utilizing the hand pump, and the certified flight instructor's failure to utilize the blow down emergency landing gear system. The instructor's inadequate…NTSB DFW05CA177Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · Gillett, ARThe loss of engine power resulting from a disconnected discharge pressure line at the fuel control unit. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA174Accident · No injuriesData collectionFinal reportLearjet 25 · Amarillo, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the prevailing crosswind.NTSB DEN05LA109Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Canon City, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors include the crosswind and windshear conditions.NTSB DCA05WA081Accident · No injuriesForeign investigationMcdonnell Douglas DC-10-30 · Chittagong, BangladeshNTSB CHI05LA173Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Crete, ILThe separation of the drive belt, during cruise, leading to the puncturing of the oil cooler and subsequent fire. An additional cause was the pilot's restricted lookout during the emergency landing resulting in the hard landing.NTSB CHI05CA161Accident · Minor injuriesData collectionFinal reportMueller Stewart Headwind B · Cloverdale, INThe fuel starvation leading to the loss of engine power during takeoff. Factors were the pilot's insufficient information on the fuel system and the sign that had to be circumnavigated during the forced landing.NTSB ATL05CA123Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Shorter, ALThe pilot's failure to maintain directional control, which resulted in the collapse of the left main landing gear.NTSB ANC05FA090Accident · 3 fatalField investigationFinal reportCessna T207 · Nanwalek, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with an island cliff during cruise flight. A factor contributing to the accident was fog in the area of the accident.NTSB NYC05LA110Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-22 · Haverstraw, NYThe pilot's physiological condition, which resulted in his incapacitation during the flight, and subsequent loss of aircraft control.NTSB MIA05CA125Accident · No injuriesData collectionFinal reportCessna 152 · Williston, FLThe inadequate weather evaluation by the pilot-in-command which resulted in the in-flight encounter with rain and thunder that resulted in a precautionary landing and subsequent on-ground collision with a ditch.NTSB DFW05CA205Accident · No injuriesData collectionFinal reportBeech 35 · Boerne, TXThe airplane's collision with a deer during touchdown. A contributing factor was the prevailing dark night condition.NTSB DEN05FA103Accident · 3 fatalField investigationFinal reportAgusta A119 · Mancos, COa loss of engine power for undetermined reasons and the pilot's inability to get into autorotation prior to impacting the ground. A factor contributing to the accident was the helicopter's low altitude when power was lost.NTSB CHI05LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Kansas City, MOThe pilot not maintaining climb airspeed leading to the airplane's impact with the fence and terrain during takeoff. Factors in the accident were the pilot's inaccurate preflight planning calculations, the fence, and the levee.