NTSB investigations, 2003
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2003 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") = 2003 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 FTW03LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bonham, TXThe loss of engine power due to fuel starvation as result of the unapproved fuel selector valve handle installed on the aircraft by an unknown person. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Belen, NMthe pilot's improper preflight/in-flight decision making which resulted in the loss of engine power due to fuel starvation. Contributing factors include, the partial fuel selector valve failure, the pilot's intentional operation with known deficiencies in…NTSB ATL03FA061Accident · 3 fatalField investigationFinal reportCessna 177 · Old Fort, NCThe pilot's decision to continue VFR flight into IMC and his failure to maintain terrain clearance which resulted in an in-flight collision with mountainous terrain.NTSB NYC03IA066Incident · No injuriesIncident investigationFinal reportDornier 328-300 · Wellman, OHAn in-flight encounter with lightning.NTSB MIA03LA075Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Humacao, PRthe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the left side of the runway, and impacting with a ditch. Factors in this accident were; the pilot did not follow the procedures, and…NTSB DEN03LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Delta, COthe loss of engine power due to company maintenance personnel's inadequate major engine overhaul (an oil pressure fitting in the engine accessory drive case had not been capped). Contributing factors were the loss of engine oil, and lack of suitable terrain…NTSB NYC03LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mineral, VAThe flight instructor's delayed remedial action.NTSB FTW03LA110Accident · No injuriesLimited investigationFinal reportCessna 177A · England, ARThe pilot's failure to refuel the airplane while searching for a private grass airstrip, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA03WA031Accident · No injuriesForeign investigationBoeing 747-300F · JohannesburgNTSB DCA03WA030Accident · No injuriesForeign investigationBoeing 747-400 · Auckland, New ZealandNTSB LAX03LA112Accident · No injuriesLimited investigationFinal reportCessna 172R · Thermal, CAthe student pilot's failure to use aileron controls to compensate for the known crosswind and failure to maintain directional control during the landing rollout.NTSB LAX03FA111Accident · 3 fatalField investigationFinal reportBeech 3NM · Anza, CAthe failure of the pilot to maintain an adequate airspeed resulting in a stall and loss of control.NTSB ENG03RA012Incident · No injuriesForeign investigationBoeing 737-200 · Kelona, BC, CanadaNTSB DEN03LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Buena Vista, COthe pilot's failure to maintain aircraft control. Contributing factors were the crosswind weather condition and gusty wind condition.NTSB NYC03LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Linden, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Factors in the accident were the crosswind and the snowbank.NTSB MIA03CA074Accident · No injuriesData collectionFinal reportSchempp-Hirth DISCUS-2B · Clermont, FLAn in-flight encounter with wind gusts while making an approach to land in a field resulting in the aircraft landing early and colliding with a berm.NTSB CHI03FA080Accident · 2 fatalField investigationFinal reportMooney M20J · Tower, MIThe pilot's failure to maintain aircraft control during cruise flight. A factor to the accident was the clouds and night conditions.NTSB FTW03WA128Accident · 5 fatalForeign investigationCessna R172HP · Ocana, ColombiaNTSB FTW03LA108Accident · No injuriesLimited investigationFinal reportWaco UKS-7 · El Paso, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the crosswind.NTSB FTW03LA107Accident · No injuriesLimited investigationFinal reportCessna 150K · Sherman, TXThe flight instructor's failure to refuel the airplane which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03LA047Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Colo Springs, COthe pilot's failure to maintain aircraft control during initial climb which resulted in impact with terrain. Contributing factors include the downdraft, crosswind and gusty wind conditions.NTSB ATL03LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NCThe pilot's improper flare during touchdown and failure to properly recover from a bounced landing, which resulted in a loss of control and inflight collision with the runway. A factor was the pilot did not understand the porpoise condition during landing.NTSB ATL03LA058Accident · No injuriesLimited investigationFinal reportCessna 172 M · Collegedale, TNThe student pilot's failure to maintain directional control, which resulted in a loss of control, impact with terrain and subsequent nose over.NTSB ANC03LA031Accident · No injuriesLimited investigationFinal reportCessna 185 · Galena, AKThe failure of the airplane to climb after takeoff which resulted in an in-flight collision with terrain during an aborted landing attempt.NTSB NYC03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · South Woodstock, CTThe pilot's failure to maintain directional controlNTSB NYC03LA063Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Zelienople, PAThe failure of the tail rotor assembly due to improper maintenance by the owner/pilot.NTSB LAX03LA110Accident · No injuriesLimited investigationFinal reportKolb Firestar · San Diego, CApropeller delamination due to the pilot's failure to properly secure the rear seat shoulder harness prior to flight. A contributing factor was the soft ground in which the airplane landed.NTSB IAD03LA037Accident · No injuriesLimited investigationFinal reportBeech 23 · Cincinnati, OHThe second pilot's inadequate flare and the pilot/owner's lack of remedial action, which resulted in a hard landing. A factor was the wind gusts.NTSB FTW03LA119Accident · No injuriesLimited investigationFinal reportCessna 150 · Pearland, TXThe pilot's failure to maintain runway alignment. Contributing factors were the pilot's diverted attention to the banner staging area, and the ditch.NTSB DEN03FA045Accident · 3 fatalField investigationFinal reportPiper PA-46-500TP · Albuquerque, NMThe pilot's unstabilized approach and his failure to maintain obstacle clearance. Contributing factors were the dark night light condition, and the static wires.NTSB CHI03LA091Accident · No injuriesLimited investigationFinal reportAviat A-1 · Cahokia, ILThe pilot’s inadequate compensation for wind and his failure to maintain directional control of the airplane which resulted in a ground loop. A factor associated with the accident was the gusty crosswind condition.NTSB CHI03LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Callao, MOA loss of engine power due to the erosion of the number 2 piston, resulting in loss of compression on that cylinder. Contributing factors were the tailwind, the muddy runway condition, and the roadway and ditch.NTSB CHI03LA081Accident · No injuriesLimited investigationFinal reportCessna 180K · St Charles, MOThe pilot's inadequate compensation for wind and his failure to maintain directional control resulting in a ground loop. A factor was the crosswind.NTSB ATL03LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Camden, SCThe pilot's inadequate preflight planning which resulted in fuel exhaustion, subsequent loss of engine power and an in-flight collision with terrain.NTSB ATL03LA056Accident · No injuriesLimited investigationFinal reportFokker F.27MK 500 · Kinston, NCThe fatigue failure of the main drag stay tube. A factor is no inspection procedure required.NTSB ATL03FA055Accident · 1 fatalField investigationFinal reportBeech A-36 · Milledgeville, GAThe pilot's improper IFR procedure by which he failed to maintain the minimum descent altitude, and his failure to maintain obstacle clearance. A factor was low the ceiling.NTSB LAX03FA109Accident · 2 fatalField investigationFinal reportCessna 172L · Rosamond, CAthe pilot's failure to maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall and impact with flat level terrain. Also causal was the pilot's impaired judgment due to recent use of cocaine, and ethanol.NTSB LAX03FA108Accident · Minor injuriesField investigationFinal reportStinson 108-1 · Eloy, AZa loss of engine power caused by the fatigue failure of the number 4 cylinder exhaust valve.NTSB DEN03LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Richfield, UTthe pilot's failure to maintain aircraft control during landing roll resulting in a ground loop/swerve and subsequent nose over. A contributing factor was the gusty wind conditions.NTSB ATL03LA059Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Gordo, ALFatigue failure of the crankshaft.NTSB FTW03LA106Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350B2 · Venice, LAThe pilot's inability to maintain directional control following a loss of tail rotor drive. A contributing factor was the fog.NTSB FTW03LA105Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA341G · Alpine, TXThe pilot's failure to maintain translational lift, which resulted in an uncontrolled descent of the helicopter during takeoff. A contributing factor was the gusty tailwind condition.NTSB FTW03LA104Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Kingsland, TXThe loss of tail rotor drive as a result of a blanket coming in contract with the tailrotor blades, after the aft cargo door was left unsecured. Contributing factors were the lack of suitable terrain for the forced landing, and the failure of the medical…NTSB DCA03RA029Accident · 102 fatalForeign investigationBoeing 737-2T4 · Tamanrassett, AlgeriaNTSB CHI03FA078Accident · 2 fatalField investigationFinal reportBeech A36 · Sparta, ILThe pilot's inadequate in-flight planning/decision by his flight into known icing conditions which resulted in airframe icing and degraded aircraft performance until the onset of a stall.NTSB SEA03LA043Accident · No injuriesLimited investigationFinal reportCessna 208B · Creswell, ORWater contamination in the fuel system which resulted in a loss of engine power during the initial climb after takeoff, and the pilot's inadequate pre-flight inspection. Trees were a factor.NTSB SEA03FA042Accident · 4 fatalField investigationFinal reportPiper PA-34-220T · Rexburg, IDThe pilot's failure to maintain aircraft control while on final approach. High and gusting winds were a factor.NTSB MIA03LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Placid, FLthe pilot-in-command's failure to maintain airspeed during climb, which resulted in the airplane stalling, and impacting with a house.NTSB LAX03LA106Accident · No injuriesLimited investigationFinal reportCessna 421C · Crescent City, CAThe separation of the upper and lower right main landing gear scissor links due to improper maintenance, which resulted in a ground loop, and the collapse of the right main landing gear during the landing roll.NTSB CHI03LA079Accident · No injuriesLimited investigationFinal reportCessna 172R · St. Paul, MNThe loss of directional control by the solo student pilot. A factor to the accident was the excessive speed during landing.