NTSB investigations, 2004
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 2004 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") = 2004 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 NYC04LA212Accident · No injuriesLimited investigationFinal reportCessna 182H · Nashua, NHAn in flight collision with birds while landing. A factor was the night conditions.NTSB FTW04WA244Accident · 1 fatalForeign investigationPiper PA-25-235 · Santa Rosa, EcuadorNTSB FTW04FA235Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Rachel, TXThe total failure of the vacuum pump that resulted in an inoperative attitude gyro and spatial disorientation and a subsequent loss of aircraft control by the pilot. Factors were; the prevailing instrument meteorological conditions, and the dark night light…NTSB CHI04CA251Accident · No injuriesData collectionFinal reportCessna 182T · Lake In The Hil, ILthe excessive descent rate resulting in a hard landing.NTSB ATL04LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Kennesaw, GAThe loss of engine power for undetermined reasons.NTSB SEA04WA184Accident · 2 fatalForeign investigationRobinson R44 · Roma, AustraliaNTSB SEA04CA185Accident · Minor injuriesData collectionFinal reportCessna 180H · McCall, IDThe pilot's failure to attain proper touchdown point for landing on the backcountry airstrip. Contributing factors were downdraft weather conditions and the pilot's excessive speed for landing.NTSB NYC04CA207Accident · No injuriesData collectionFinal reportCessna 402C · Charleston, WVThe pilot's improper decision to abort the takeoff with insufficient runway remaining. A factor was the wet runway.NTSB LAX04LA333Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 900 · Mesa, AZfracture of a Tension-Torsion strap in the anti-torque fan due to progressive fiber failure of the composite strap material from compression and/or transverse shear stresses that occurred with repeated manipulation of the cockpit anti-torque control pedals…NTSB DEN04LA140Accident · No injuriesLimited investigationFinal reportBeech B-60 · Casper, WYthe missing nose gear assembly bolt, spacer and nut resulting in a gear collapse due to improper maintenance procedures. Contributing to the accident was the collision with the storm drain.NTSB ANC04LA112Accident · No injuriesLimited investigationFinal reportCessna 170 · Teller, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate evaluation of the wind conditions, which resulted in a collision with an embankment during takeoff-initial climb. Factors contributing to the accident was the presence of a sand…NTSB NYC04CA206Accident · No injuriesData collectionFinal reportCessna 172S · Mount Gilead, OHThe pilot's inadequate compensation for wind conditions which resulted in a collision with the runway. A factor was the crosswind.NTSB DEN04LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Gillette, WYimproper engine overhaul performed by the mechanic which resulted in the fractured exhaust valve and subsequent partial loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN04LA135Accident · No injuriesLimited investigationFinal reportCessna 180 · Buena Vista, COThe pilot's failure to maintain directional control. Contributing to the accident was the gusty winds and the dirt devil encountered by the aircraft.NTSB DEN04FA134Accident · 1 fatalField investigationFinal reportMooney M20D · Pagosa Springs, COthe pilot's inadequate preflight planning and his failure to maintain directional control. Contributing factors were the pilot's failure to abort the takeoff, and the rough and uneven runway surface.NTSB ATL04CA189Accident · No injuriesData collectionFinal reportBeech D18S · Tullahoma, TNRight tire burst during an attempted takeoff that resulted in loss of directional control and the on ground collision with the ground.NTSB ANC04LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Kenai, AKThe pilot's selection of an unsuitable landing/takeoff site, which resulted in a loss of control and a nose over during an aborted takeoff. Factors in the accident were soft terrain, and the pilot's failure to maintain directional control.NTSB ANC04CA105Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with vegetation and a nose over. A factor contributing to the accident was a tailwind.NTSB SEA04LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Blaine, WAThe instructor pilot's inadequate remedial action during his student's final approach for a simulated engine out water landing.NTSB SEA04LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Port Angeles, WAThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors contributing to the accident included the fence and the ditch.NTSB SEA04LA180Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Picabo, IDThe pilot's failure to set the propeller control for takeoff performance needed to outclimb obstacles. The pilot's failure to use the checklist, trees, and a fence are contributing factors.NTSB NYC04CA205Accident · No injuriesData collectionFinal reportPiper PA32-300 · Montauk, NYThe pilot's failure to maintain altitude\clearance while landing. A factor in this accident was the gusty wind conditions.NTSB MIA04LA127Accident · No injuriesLimited investigationFinal reportMooney M20F · Brandon, MSA loss of engine power due to the fatigue failure of all studs and/or thru-bolts of the No. 3 cylinder for undetermined reasons causing separation of the cylinder. Contributing to the accident was the unsuitable terrain encountered by the pilot.NTSB LAX04LA314Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe certified flight instructor's misjudged flare and delayed recovery from the practice autorotation.NTSB IAD04LA044Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Penn Yan, NYthe pilot's loss of directional control during landing which resulted in excessive side-loads and failure of the right main landing gear wheel.NTSB ANC04CA111Accident · No injuriesData collectionFinal reportChampion 7GCBC · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the collapse of the right main landing gear during the landing roll. A factor contributing to the accident was rough and uneven terrain.NTSB SEA04LA181Accident · No injuriesLimited investigationFinal reportHughes 369D · Cottage Grove, ORIn-flight loss of engine power during cruise for undetermined reasons.NTSB NYC04LA204Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Louisville, KYThe improper refueling of the left auxiliary fuel tank, which resulted in an overflow of fuel, and a subsequent explosion in the left wing during engine start.NTSB MIA04LA131Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · St. ThomasThe failure of the pilot-in-command to comply with performance data related to the recommended takeoff profile and his failure to perform remedial action following reduced tailrotor effectiveness, resulting in subsequent initiation of an autorotation and…NTSB FTW04FA232Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Corsicana, TXThe loss of engine power due to a faulty carburetor and the pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during the forced landing after takeoff.NTSB DEN04LA138Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Colorado Spring, COright main tire failure for reasons undetermined.NTSB CHI04LA249Accident · Serious injuriesLimited investigationFinal reportJohnson-Moore Zenith CH 701 · Galena, MOA loss of directional control for undetermined reasons. A factor associated with the accident was the tree that the airplane contacted.NTSB CHI04LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · Gary, INThe failure of the nose wheel for undetermined reasons. A factor associated with the accident was the student pilot's failure to properly flare the airplane.NTSB CHI04CA252Accident · No injuriesData collectionFinal reportCessna T310R · Marshall, MNThe pilot rated passenger selecting an improper fuel selector position, and the pilot in command not verifying the fuel selector position which resulted in fuel starvation. Contributing factors were the pilot's failure to feather the right engine propeller…NTSB CHI04CA247Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grant, NEDirectional control not attained and the control interference encountered by the pilot during landing roll. The ditch was a contributing factor.NTSB CHI04CA246Accident · Minor injuriesData collectionFinal reportUtterback Mustang II · Kendallville, INThe pilot's improper recovery from a bounced landing and his failure to maintain aircraft control.NTSB ATL04LA173Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401B · Bainbridge, GAThe pilot's failure to maintain adequate airspeed during an abrupt maneuver which resulted in a stall and collision with the ground.NTSB ATL04CA174Accident · No injuriesData collectionFinal reportGrumman American AA1C · Boone, NCThe pilot's selection of the wrong runway, and his misjudgment of the distance and speed during the approach to land, which resulted in the overrun of the runway surface and subsequent collision with trees. A factor was tailwind.NTSB ANC04LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Cantwell, AKAn in-flight fire for an undetermined reason, which resulted in an off-airport forced landing and subsequent destruction of the airplane by fire.NTSB ANC04FA102Accident · 2 fatalField investigationFinal reportPiper PA-12 · Koliganek, AKThe pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an inadvertent stall and an uncontrolled descent.NTSB SEA04LA179Accident · Minor injuriesLimited investigationFinal reportHardin Lancair 320 · Chewelah, WAFuel exhaustion as a result of a fuel leak from an undetermined location resulting in a loss of engine power during approach for landing and subsequent forced landing. Soft terrain was a factor.NTSB NYC04CA202Accident · Minor injuriesData collectionFinal reportCessna 305A · Lawrence, MAThe pilot's inadvertent pickup of a banner towline with the airplanes main landing gear after encountering gusting wind conditions. A factor related to the accident was the gusting wind conditions.NTSB MIA04LA126Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Greenville, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply is a contributing factor.NTSB LAX04LA312Accident · No injuriesLimited investigationFinal reportBeech F33A · Fresno, CAthe pilot's loss of pitch control authority during landing flare due to an autopilot system failure that inhibited control yoke movement. A factor was inadequate autopilot system maintenance.NTSB FTW04LA231Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mountain Home, TXThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB FTW04CA233Accident · No injuriesData collectionFinal reportSenior Aero Sport D-260 · Mc Kinney, TXThe pilot's failure to obtain and maintain proper alignment with the runway centerline during the landing roll.NTSB DEN04LA133Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hayden, COthe pilot's failure to maintain aircraft control during landing. Contributing factors include the excessive crosswind component, and the gusty wind conditions.NTSB ANC04LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's failure to compensate for a crosswind during the landing roll, and his failure to maintain directional control which resulted in a loss of control, an encounter with a ditch, and the airplane nosing over. A factor in the accident was a crosswind.NTSB LAX04LA313Accident · 2 fatalLimited investigationFinal reportRedgate Europa Classic · Marble Canyon, AZan in-flight collision with terrain for undetermined reasons.NTSB LAX04CA310Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Maricopa, AZthe pilot's encounter with a dust devil during landing flare, which resulted in a hard touchdown.