NTSB investigations, 2004
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 LAX05CA030Accident · No injuriesData collectionFinal reportCessna P210N · Rancho Cordova, CAThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power. Contributing factors were the pilot's improper in-flight decision to continue the flight at night after experiencing the total failure of the…NTSB IAD05LA011Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Clarksburg, WVThe pilot's inability to operate the airplane's brake pedals which resulted in the loss of aircraft control.NTSB ATL05WA029Accident · No injuriesForeign investigationRobinson R22 · Madrid, SpainNTSB SEA05LA014Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Boise, IDThe pilot's failure to maintain the required glidepath, and his failure to maintain obstacle clearance after visual contact with the runway during the instrument approach.NTSB MIA05LA037Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, FLThe improper flare by the pilot in command resulting in a hard landing, Restricted movement of the throttle was a contributing factor.NTSB LAX05LA020Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350-BA · Oxnard, CAThe inadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was likely due to a combination of the reduced clearance between the lock plate and the…NTSB DFW05LA019Accident · Minor injuriesLimited investigationFinal reportBell 206L1 · Sapulpa, OKThe loss of tail rotor drive as a result of a blanket coming in contact with the tail rotor blades, after the baggage compartment door unlatched during flight. A contributing factor was the "dusk" light condition that prevailed at the time of the accident.NTSB DFW05LA022Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Eagle Pass, TXThe pilot's failure to maintain control of the helicopter. A contributing factor was the unsuitable terrain for landing.NTSB CHI05FA024Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Detroit, MIThe pilot's failure to feather the propeller and to maintain control of the airplane following the loss of engine power which resulted from undetermined reasons. Factors associated with the accident were the power lines and the house that the airplane…NTSB ATL05LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Chamblee, GAThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. .NTSB MIA05CA034Accident · No injuriesData collectionFinal reportBeech 58 · Fort Pierce, FLThe failure of the pilot to follow the checklist and extend the landing gear during landing resulting in a gear-up landing.NTSB MIA05CA022Accident · No injuriesData collectionFinal reportChampion 7GCBC · Pierson, FLThe inadequate visual lookout by the pilot-in-command resulting in the airplane encountering uneven terrain, propeller contact to the ground, and subsequent nose over.NTSB DCA05WA008Incident · No injuriesForeign investigationBoeing B767-200 · Manchester, United KingdomNTSB DCA05WA005Accident · No injuriesForeign investigationBoeing B747-230C · Sharjah, United Arab EmiratesNTSB NYC05CA018Accident · No injuriesData collectionFinal reportKinner Sportster · Millbrook, NYThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor was the crosswind.NTSB LAX05FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Mesa, AZthe pilot's failure to obtain and maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall/spin.NTSB DFW05LA023Accident · No injuriesLimited investigationFinal reportCessna 150M · Longview, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB CHI05LA026Accident · 1 fatalLimited investigationFinal reportBruce Protech PT2B · Anita, IAThe pilot's failure to maintain sufficient airspeed and an inadvertent stall/spin resulting in loss of control and an in-flight collision with terrain. An additional cause was a loss of engine power for undetermined reasons.NTSB CHI05LA023Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Wasta, SDThe pilot inadvertently pulled the fuel shut off valve resulting in fuel starvation and a subsequent loss of engine power. The pilot also failed to maintain adequate airspeed which resulted in the airplane stalling.NTSB CHI05CA025Accident · No injuriesData collectionFinal reportJabat Avid Flyer · Cleveland, MOThe separation of the wing skin from the wing structure and the pilot's subsequent inablility to maintain aircraft control. A factor associated with the accident was the tree that the airplane contacted.NTSB CHI05CA022Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Morris, ILThe pilot's inadequate preflight planning in that he failed to assure that the airplane was properly secured prior to hand propping the engine. Factors associated with the accident were the broken tie down rope and the other airplanes which were contacted.NTSB ATL05CA021Accident · No injuriesData collectionFinal reportCessna 152 · Rocky Mount, NCThe pilot's improper landing flare, and improper recovery from a bounced landing.NTSB MIA05FA024Accident · 2 fatalField investigationFinal reportSocata TB 20 · Key West, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation. A related factor was the dark, night conditions.NTSB LAX05FA026Accident · 1 fatalField investigationFinal reportCessna T210M · Lomita, CAA loss of engine power due to fuel starvation as a result of the pilot's mismanagement and inadequate preflight inspection.NTSB LAX05CA028Accident · No injuriesData collectionFinal reportCessna 172S · Chandler, AZthe pilot's improper flare, which resulted in a hard landing. Contributing factors were his improper recovery from the subsequent bounced landing and pilot-induced oscillations.NTSB DFW05LA017Accident · Serious injuriesLimited investigationFinal reportBell 206B · S.Timbelier 187The loss of engine power for undetermined reasons.NTSB DFW05LA016Accident · Serious injuriesLimited investigationFinal reportWilson Loenslo YMF-80 · Arcola, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff initial climb.NTSB DFW05FA015Accident · 1 fatalField investigationFinal reportPiper PA-30 · Boise City, OKThe pilot's incapacitation (cardiovascular) resulting in a loss of aircraft control.NTSB DEN05CA021Accident · No injuriesData collectionFinal reportTemco GC-1B · Angel Fire, NMthe pilot's failure to maintain directional control and his inadequate compensation for wind. Contributing to the accident was the crosswind.NTSB DEN05CA020Accident · No injuriesData collectionFinal reportMooney M20E · Santa Rosa, NMInadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.NTSB ATL05LA020Accident · Serious injuriesLimited investigationFinal reportFranzreb Loehle 5151 Mustang · Athens, TNThe loss of engine power due to the electrical fuel pump failure, and fuel starvation.NTSB MIA05CA039Accident · No injuriesData collectionFinal reportRobinson R-22 · Daytona Beach, FLThe improper landing flare by an unknown pilot at an unknown time resulting in a hard landing and substantial damage to the helicopters tailcone.NTSB IAD05LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA jammed control wheel during landing. A contributing factor to the accident was the inadequate maintenance inspection of the airplane's flight control system.NTSB DCA05WA007Incident · No injuriesForeign investigationBoeing B747-300 · Paris, FranceNTSB DCA05WA006Accident · Minor injuriesForeign investigationBoeing B737-300 · Kota Kinabalu, MalaysiaNTSB MIA05WA025Accident · Minor injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasNTSB MIA05LA021Accident · 1 fatalLimited investigationFinal reportJ.D. Calhoun Vans Acft RV6A · Weirsdale, FLFailure of the nose landing gear for undetermined reasons, resulting in the airplane nosing over during the landing roll, and the pilot's decision to operate the airplane with known deficiencies in the nose landing gear. A factor contributing to the fatality…NTSB ATL05CA019Accident · Serious injuriesData collectionFinal reportCessna 172N · Columbia, SCThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB MIA05FA020Accident · 1 fatalField investigationFinal reportRawdon Bros. T1 · Pembroke Pines, FLImproper maintenance by company maintenance personnel, and the pilot-in-command's operating the airplane with known deficiencies, which resulted in the loss of engine power due to fuel system contamination, and a loss of control while maneuvering to return to…NTSB LAX05LA025Accident · No injuriesLimited investigationFinal reportEurocopter AS350B3 · Sierra Vista, AZAn inconsistency between the engines' two N2 sensor signals caused the fuel control to enter a fixed mode, which limited the power available. Contributing to the accident was the lack of altitude and airspeed available to give the pilot time to select a…NTSB IAD05LA009Accident · No injuriesLimited investigationFinal reportCessna 120 · Willimantic, CTthe pilot's loss of directional control due to his uneven application of brakes. A factor in the accident was the tailwind.NTSB DEN05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTthe loss of engine power due to carburetor icing. Contributing factors include the weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced landing.NTSB DEN05CA018Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Salt Lake City, UTthe dual student's high flare resulting in an inadvertent stall/mush and a hard landing. A factor contributing to the accident was the flight instructor's inadequate supervision.NTSB LAX05LA027Accident · No injuriesLimited investigationFinal reportCessna 172RG · Kingman, AZLanding gear extension system component failure resulting in a gear up landing.NTSB MIA05LA018Accident · No injuriesLimited investigationFinal reportCessna 340A-RAM VI · Pensacola, FLThe left landing gear collapsing due to the actuator separating for undetermined reasons.NTSB LAX05LA022Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Martin, CAA loss of power for undetermined reasons.NTSB LAX05FA023Accident · 4 fatalField investigationFinal reportCessna 182Q · Lebec, CAthe pilot's inadequate in-flight planning/decision by his VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were mountainous terrain, low ceilings, and turbulence.NTSB DFW05WA013Accident · Serious injuriesForeign investigationBölkow BO-105-LS · Puerto Plata, Dominican RepublicNTSB DEN05LA017Accident · Serious injuriesLimited investigationFinal reportMiller Vans RV4 · Dotsero, COthe pilot's improper in-flight planning and decision making and the loss of engine power due to carburetor ice. Contributing factors include the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB CHI05CA027Accident · No injuriesData collectionFinal reportCessna T182T · Morris, ILThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control. Factors associated with the accident were the gusty crosswind condition and the runway sign which the airplane contacted.