NTSB investigations, 2003
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\") = 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 LAX03LA267Accident · 1 fatalLimited investigationFinal reportPetz Flying Boat · Tracy, CAThe inadequate design of the engine exhaust system and inappropriate selection of propeller materials by the designer/builder, which resulted in separation of the propeller blades during takeoff/initial climb, and a subsequent in-flight collision with terrain…NTSB FTW03LA209Accident · No injuriesLimited investigationFinal reportPilatus PC-6/C-H2 · Vigo Park, TXThe loss of propeller pitch control for undetermined reasons.NTSB CHI03FA296Accident · 2 fatalField investigationFinal reportBeech 58P · Grand Marais, MNThe continued descent below minimum descent altitude and the altitude/clearance not maintained by the pilot during approach to the airport. The low ceiling was a contributing factor.NTSB SEA03LA180Accident · No injuriesLimited investigationFinal reportLancair LC41 · Bend, ORThe inadequate design of the drogue chute mechanical jettison system, which resulted in its failure to separate from the aircraft during in-flight spin recovery tests, and the incorrectly wired drogue chute cable cutter activation unit, which resulted in the…NTSB MIA03WA172Accident · 1 fatalForeign investigationPiper PA-38-112 · Penalolen, ChileNTSB MIA03LA171Accident · No injuriesLimited investigationFinal reportBeech 23 · Punta Gorda, FLA loss of engine power for undetermined reasons.NTSB SEA03FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Warm Lake, IDThe pilot's failure to maintain adequate airspeed during final approach resulting in a stall/spin. Contributing factors were the rapidly rising terrain and trees.NTSB SEA03CA178Accident · No injuriesData collectionFinal reportBeech C24R · Bend, ORThe first pilot's premature liftoff and his failure to abort the takeoff. Factors include a fence and a ditch bank located upwind of the runway.NTSB NYC03MA183Accident · 2 fatalMajor investigationFinal reportBeech 1900D · Yarmouth, MAThe improper replacement of the forward elevator trim cable, and subsequent inadequate functional check of the maintenance performed, which resulted in a reversal of the elevator trim system and a loss of control in-flight. Factors were the flightcrew's…NTSB ANC03LA103Accident · No injuriesLimited investigationFinal reportCessna 180 · Nenana, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power and a forced landing in unsuitable terrain.NTSB SEA03FA179Accident · No injuriesField investigationFinal reportAero Commander Callair A-9B · Driggs, IDA loss of engine power due to the improper installation of a counterweight roller pin retaining washer circlip, leading to the circlip coming out of its groove and the counterweight roller pin coming in contact with two of the engines connecting rods.…NTSB LAX03LA265Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Avenal, CAthe pilot's failure to maintain directional control during a precautionary landing. The reason for the partial loss of engine power was undetermined.NTSB LAX03LA262Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Brownsville, CAThe pilot's improper flare and his failure to maintain directional control. Contributing factors were excessive airspeed, pilot-induced oscillation, and inadequate recovery from a bounced landing.NTSB LAX03FA282Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Encinitas, CAThe student pilot's spatial disorientation and inadvertent descent into the ocean while maneuvering to avoid inclement weather. Also causal was the flight instructor's inadequate supervision due to his improper approval of his student's preflight preparation…NTSB LAX03CA264Accident · No injuriesData collectionFinal reportHughes 269C · Columbia, CAthe student pilot's improper execution of the autorotation. Also causal, was the CFI's delayed remedial action and supervision of the flight.NTSB LAX03CA263Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Pauma Valley, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall. The rising terrain was a factor.NTSB FTW03LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winnsboro, LAThe pilot's inadequate 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 FTW03LA203Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Ozona, TXThe pilot's decision to hover out of ground effect, which resulted in a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB CHI03LA288Accident · No injuriesLimited investigationFinal reportBeech M35 · Avon, ILThe pilot's inadequate fuel managemant leading to fuel starvation during cruise flight and the unsuitable terrain she encountered during the forced landing. A factor was her lack of total time in the airplane make and model.NTSB CHI03LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Deer Grove, ILThe pilot's failure to attain the proper touchdown point, and his failure to execute a go-around.NTSB SEA03LA176Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Hood River, ORA power loss due to a mis-seated intake valve on the #1 cylinder resulting in leakage during the compression stroke and low compression. Contributing factors were the rising terrain and trees.NTSB NYC03FA180Accident · 1 fatalField investigationFinal reportAero Vodochody L-39ZO · Forest Hill, MDThe pilot's in-flight decision to delay application of engine power to account for the engine's slow response to throttle input, which resulted in an inadvertent stall and subsequent collision with a residential area. A factor related to the accident was the…NTSB MIA03IA168Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Miami, FLThe failure of maintenance personnel from the aircraft operator to identify a missing left main landing gear truck beam shield and damage to the left main landing gear truck beam which resulted in the fracture of the truck beam as a result of stress corrosion…NTSB LAX03CA266Accident · No injuriesData collectionFinal reportCessna 172M · Riverside, CAThe student pilot's misjudged distance and altitude, and the instructor's inadequate supervision of the flight. Also causal was the instructor's delayed remedial action.NTSB DEN03IA147Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe first officer's improper preflight preparation in failing to ensure the cabin airstair door was fully locked and secure. Factors relating to the incident were the cabin airstair door handle not being fully secure and the forward cabin door warning light…NTSB CHI03LA297Accident · No injuriesLimited investigationFinal reportAyres S-2R · Eudora, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the trees and the ditch which the airplane contacted during the forced landing.NTSB CHI03LA285Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Omaha, NEThe pilot not maintaining aircraft control during the landing roll. Factors were the grass the airplane encountered when the airplane ground looped off the runway and the main gear collapsed.NTSB CHI03LA282Accident · 1 fatalLimited investigationFinal reportCessna 140 · Edwardsburg, MIThe pilot not maintaining altitude/clearance from the power line during his low level cruise. Factors were the power transmission line, the lake, and low altitude flight.NTSB ANC03LA102Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kenai, AKThe pilot's inadequate compensation for a crosswind during the landing roll, which resulted in a loss of control and subsequent ground loop. A factor in the accident was a crosswind.NTSB SEA03LA177Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Nampa, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. A factor was the unsuitable terrain for the forced landing.NTSB NYC03LA181Accident · No injuriesLimited investigationFinal reportCessna A185F · Marion, OHFatigue and corrosion of the right main landing gear attachment, which resulted in a gear collapse while landing.NTSB NYC03CA182Accident · No injuriesData collectionFinal reportKucklick Hiperbipe · Marion, OHThe pilot's improper decision to install an inadequate air filter, which subsequently failed and resulted in a power loss.NTSB MIA03LA170Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Panama City, FLThe pilot's failure to follow the airplane manufacturer's recommendation to not use automobile fuel in the airplane resulting in deterioration of the fuel tank sealant, fuel starvation of the engine from fuel system contamination, and subsequent collision…NTSB FTW03LA235Accident · No injuriesLimited investigationFinal reportVelocity RG · Skiatook, OKThe pilot's delay in aborting the takeoff. A contributing factor was the high density altitude.NTSB FTW03LA206Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · McKinney, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall during landing. A contributing factor was flaring too high.NTSB CHI03LA327Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA200 · Sugar Grove, ILA loss of engine power due to the pilot's inadvertent deactivation of the magnetos, and the pilot's selection of the wrong runway for the forced landing. Factors were the low altitude and the unsuitable terrain encountered during the forced landing.NTSB CHI03LA281Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fennimore, WIThe loss of engine power in cruise flight due to carburetor icing. A factor was the unsuitable terrain the pilot encountered during his forced landing.NTSB CHI03LA280Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSFailure of the maintenance crew to provide adequate clearance to an active taxiway during the engine run-up. Contributing factors were the failure of the control tower to provide a wake turbulence advisory to the accident aircraft when assigning a taxi route…NTSB CHI03LA265Accident · No injuriesLimited investigationFinal reportCessna 188B · Monette, ARFailure of the right brake and the pilot's inability to maintain directional control. A factor associated with the accident was the ditch.NTSB ANC03LA101Accident · No injuriesLimited investigationFinal reportCloud-Wag Aero Sportsmen · Noatak, AKThe pilot's misjudgment of the airplane's distance and speed, which resulted in the airplane not attaining the proper landing touchdown point and overrunning the landing site.NTSB LAX03LA260Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Saint Johns, AZThe failure of the exhaust valve on the number two engine cylinder, which resulted in a partial loss of engine power during the final approach to land, and an on ground collision with a ditch during the subsequent off-airport landing roll.NTSB LAX03CA261Accident · No injuriesData collectionFinal reportCessna 150C · Tucson, AZthe pilot's inadequate inflight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB FTW03CA205Accident · No injuriesData collectionFinal reportCessna 195 · Sand Springs, OKThe pilot's failure to maintain directional control during the landing roll.NTSB CHI03LA289Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Westside, IAThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing factors were the unsuitable terrain encountered, and the terrace/embankment.NTSB CHI03LA287Accident · No injuriesLimited investigationFinal reportStaudacher S-1000 · Newberry, MIThe pilot's inadequate compensation for the wind conditions, resulting in aircraft control not being maintained during the landing approach. Contributing factors to the accident were the gusting crosswind and the VASI system.NTSB CHI03LA209Accident · No injuriesLimited investigationFinal reportYoung Cozy MkIV · Quincy, ILThe pilot's improper flare.NTSB CHI03FA284Accident · 3 fatalField investigationFinal reportCessna 172S · Lake Elmo, MNBoth pilots failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft.NTSB ATL03LA132Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Camilla, GAThe malfunction (locking) of the left brake piston during the landing roll, which resulted in a loss of control and subsequent nose over.NTSB ANC03LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Glennallen, AKThe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground loop, and collapse of the main landing gear.NTSB MIA03WA178Accident · Serious injuriesForeign investigationCessna 150 · Punta Cana, Dominican Republic