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 CHI05LA128Accident · No injuriesLimited investigationFinal reportCessna T210N · Smith Center, KSFailure of the Piper airplane pilot to obtain visual separation from the Cessna airplane rolling out after landing on the intersecting runway resulting in a collision between the two aircraft. A contributing factor was the evasive maneuver attempted be the…NTSB CHI05CA133Accident · Serious injuriesData collectionFinal reportAerostar S-57A · Sparta, MOThe pilot's inability to maintain a proper descent rate due to the wind gust resulting in a hard landing. Contributing factors were the wind gust and the tree struck during the landing.NTSB ATL05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Louisburg, NCThe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent loss of control and collision with the ground.NTSB SEA05LA107Accident · No injuriesLimited investigationFinal reportCessna 150L · Spokane, WAThe pilot's inadequate in-flight decision by failing to fuel, resulting in fuel exhaustion and the loss of engine power while on approach for landing.NTSB MIA05LA111Accident · Minor injuriesLimited investigationFinal reportHamilton Stoddard Glassair II S · Palm City, FLImproper maintenance by other maintenance personnel, which resulted in the throttle cable being loose and detaching from the throttle arm during takeoff, resulting in a loss of engine power.NTSB IAD05LA070Accident · Minor injuriesLimited investigationFinal reportSnyder Sky Scout · Round Lake, NYA loss of engine power for undetermined reasons. A factor was the soft field.NTSB ATL05CA088Accident · No injuriesData collectionFinal reportCessna 172 · Raleigh, NCThe pilot's failure to maintain adequate obstacle clearance during initial climb, which resulted in an in-flight collision with treesNTSB DFW05CA137Accident · Minor injuriesData collectionFinal reportPZL-Mielec M18 · Clover Bend, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the dust devil (whirlwind) encountered.NTSB CHI05LA130Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6 · Sturtevant, WIFailure of the jump plane pilot to maintain clearance from the parachutist descent area/drop zone until assured that all jumpers had landed, and the parachutist's failure to maintain an adequate visual lookout for the jump plane during all phases of the jump.…NTSB ATL05CA089Accident · Minor injuriesData collectionFinal reportHughes TH-55 · Cornelia, GAThe pilot's failure to maintain adequate object clearance, which resulted in the in-flight collision with terrain, and the subsequent rollover.NTSB ANC05CA078Accident · No injuriesData collectionFinal reportPiper PA-31-310 · Manokotak, AKThe pilot's failure to extend the landing gear. A contributing factor was the pilot's failure to use the checklist.NTSB SEA05FA105Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-25 · Hillsboro, ORThe pilot's failure to obtain minimum controllable airspeed during the takeoff climb, which resulted in a loss of aircraft control when the left engine lost partial power. A fatigue failure to an oil tube, which resulted in the partial power loss to the left…NTSB LAX05LA187Accident · Serious injuriesLimited investigationFinal reportBell 47G-4A · Bakersfield, CAthe pilot's inadequate visual lookout and failure to maintain clearance from the power lines.NTSB LAX05CA188Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Jean, NVthe student's failure to maintain adequate main rotor rpm when performing a180-degree autorotation, and the instructor's inadequate supervision and delayed remedial action. A factor in the accident was the high density altitude.NTSB DFW05CA135Accident · No injuriesData collectionFinal reportCessna 210L · Harvey, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05CA134Accident · No injuriesData collectionFinal reportTemco GC-1B · Morris, ILMalfunction of the pilot seat positioning mechanism for undetermined reasons resulting in a loss of aircraft control. The runway light struck when the airplane departed the pavement was a contributing factor.NTSB CHI05CA127Accident · No injuriesData collectionFinal reportCessna 150F · Neodesha, KSThe student pilot's misjudgment of the landing flare resulting in a hard landing, his inadequate recovery from the bounced landing and his subsequent failure to maintain directional control of the airplane. The pilot's attempt to abort the landing, and the…NTSB MIA05WA110Accident · 2 fatalForeign investigationBeech BE-300 · Caracas, VenezuelaNTSB MIA05LA108Accident · No injuriesLimited investigationFinal reportBeech 58 · Gulfport, MSThe inadequate maintenance inspection by maintenance personnel which resulted in damaged landing gear pulleys, resulting in the failure of the landing gear downlock to engage, and collapse of the main landing gear during landing.NTSB IAD05FA068Accident · 2 fatalField investigationFinal reportCessna R182 · New Fairfield, CTFailure of the aluminum-clad, number two connecting rod bearings, which resulted in a total loss of engine power. A factor was the relatively short forced landing area.NTSB DFW05LA134Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Jennings, LAThe failure of both pilots to maintain adequate visual lookout, which resulted in a midair collision while on final approach.NTSB DFW05CA136Accident · No injuriesData collectionFinal reportCessna 152 · Conroe, TXThe pilot's improper in-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB DFW05CA133Accident · No injuriesData collectionFinal reportGrumman 164-B · Fontaine, ARThe pilot's failure to maintain clearance during a downwind takeoff with a full load of fertilizer. Factor contributing to the accident were the prevailing tailwind and the high density altitude.NTSB DFW05CA132Accident · Minor injuriesData collectionFinal reportWeatherly 201B · Tornillo, TXThe loss of engine power as result of the failure of a cylinder.NTSB DFW05CA131Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Cherry Valley, ARThe pilot's failure to calculate take off-distance performance data, which resulted in insufficient runway length for take off. Factors were the tailwind and high gross weight.NTSB CHI05LA125Accident · 1 fatalLimited investigationFinal reportHurley Searey · South Beloit, ILIn-flight collision with the ground for undetermined reasons.NTSB SEA05CA104Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Estacada, ORThe failure of the pilot to maintain landing skid clearance during hover taxi, which resulted in a dynamic rollover. A factor was the gusty wind condition.NTSB DEN05LA082Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Provo, UTthe dual student’s failure to maintain adequate rotor rpm and the inadequate supervision by the instructor.NTSB ATL05FA086Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Conway, SCThe pilot's failure to maintain airspeed while maneuvering after releasing a banner aerial sign, resulting in an inadvertent stall and collision with the ground. A factor in the accident was the flight instructor's improper supervision of the pilot receiving…NTSB ATL05CA087Accident · No injuriesData collectionFinal reportBeech BE-36 · Dahlonega, GAThe pilot's mismanagment of the fuel supply which resulted in fuel starvation and subsequent loss of engine power.NTSB ANC05CA080Accident · No injuriesData collectionFinal reportPiper PA-18 · Delta Junction, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an overrun. A factor contributing to the accident was rough and uneven terrain.NTSB NYC05FA086Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edinburg, OHThe pilot's failure to maintain aircraft control.NTSB LAX05LA186Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Santa Barbara, CAa loss of engine power due to carburetor ice aggravated by the poor operating condition of the magnetos and the improper magneto-to-engine timing.NTSB LAX05CA185Accident · No injuriesData collectionFinal reportRobinson R44 · Sedona, AZthe pilot's improperly planned approach and misjudged distance/speed. A factor was the high density altitude.NTSB DFW05CA130Accident · Serious injuriesData collectionFinal reportCessna 182P · Lowell, ARThe instructor's inadequate supervision and the second pilot's inadequate planning/decision to assure adequate takeoff performance to clear obstacles. Contributing factors were the prevailing quartering tailwind, the pilots selection of the wrong runway, and…NTSB DFW05CA128Accident · Serious injuriesData collectionFinal reportBellanca 17-30A · Houston, TXThe pilot's mismanagement of the fuel and his inadequate monitoring of the fuel supply which resulted in fuel starvation.NTSB CHI05CA126Accident · No injuriesData collectionFinal reportYoung Zodiac 601XL · Mattoon, ILThe pilot's failure to maintain control of the airplane during the landing flare resulting in an in-flight collision with the runway pavement.NTSB CHI05CA123Accident · No injuriesData collectionFinal reportCessna C-172M · Madison, WIThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors were the gusty winds and the soft ground.NTSB ATL05CA085Accident · Serious injuriesData collectionFinal reportCanadair CL600 · Augusta, GAThe pilot-in-command's improper use of the flight controls during climb which resulted in the flight attendant injury. A factor was the flight crew failure to follow written procedures during transfer of flight controls.NTSB SEA05LA103Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Emmett, IDThe partial loss of engine power during cruise flight as a result of air being sucked into the fuel system due to a worn fuel selector valve stem and a hardened and brittle fuel selector valve O-ring. Factors include no suitable landing area within the…NTSB SEA05LA101Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Driggs, IDThe pilot's failure to compensate for wind conditions, which resulted in a ground loop/swerve during the landing roll. A crosswind was a factor.NTSB MIA05LA107Accident · Serious injuriesLimited investigationFinal reportC.W. Smith Rans S6 Coyote II · Louisville, MSGalling of the front piston and cylinder of the Rotax 503 2-stroke engine, consistent with the engine running hot and lean for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB MIA05LA106Accident · Minor injuriesLimited investigationFinal reportPitts S1S · Lake Wales, FLImproper maintenance inspection by other maintenance personnel, which resulted in a loose fuel line fitting going undetected, a fuel leak onto exhaust piping, and a fire.NTSB LAX05LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Avalon, CAfuel exhaustion due to the pilot's inadequate preflight and failure to refuel the airplane prior to takeoff.NTSB IAD05FA067Accident · 4 fatalField investigationFinal reportCessna 172S · Brooklyn, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.NTSB DFW05LA129Accident · 1 fatalLimited investigationFinal reportMiller Rand Robinson KR-2 · Galliano, LAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin during initial takeoff climb. A contributing factor was the pilot's lack of experience for the make/model airplane.NTSB DEN05LA115Accident · No injuriesLimited investigationFinal reportHepperlen RV-8 · Durango, COthe pilot's failure to maintain directional control during the ground roll.NTSB CHI05LA122Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Vandalia, ILThe pilot's failure to maintain control of the airplane due to undetermined reasons.NTSB CHI05LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mt. Pleasant, MIThe pilot's misjudged distance/speed which led to an overrun and collision with a vehicle. Contributing to the accident was the flight instructor's delayed remedial action in executing a go-around.NTSB CHI05CA124Accident · No injuriesData collectionFinal reportCessna 172S · Port Huron, MIThe pilot not performing a go-around and misjudging the flare leading to a hard landing.