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 LAX04LA044Accident · Minor injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Pacoima, CAThe student pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with a sign and an unoccupied airplane.NTSB NYC04LA046Accident · No injuriesLimited investigationFinal reportCessna 172E · Islip, NYThe pilot's failure to maintain aircraft control, which resulted in a nose over. A factor in this accident was the gusty wind conditions.NTSB MIA04FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-300 · Missing, BahamasUndetermined.NTSB LAX04WA148Accident · 2 fatalForeign investigationPiper PA-34-200 · New South Wales, AustraliaNTSB LAX04LA043Accident · No injuriesLimited investigationFinal reportCessna 208B · Phoenix, AZthe pilot's improper decision to taxi behind another airplane conducting an engine run-up, which resulted in a jet blast encounter.NTSB LAX04FA042Accident · 1 fatalField investigationFinal reportCessna 177RG · Blk Canyon City, AZa loss of engine power due to the failure of the single-drive dual magneto that resulted from inadequate lubrication of the breaker cam. Also causal was the improper maintenance by other maintenance personnel during a recent inspection, which should have…NTSB FTW04WA035Accident · 2 fatalForeign investigationBell 206L4 · Urucu, BrazilNTSB CHI04LA033Accident · No injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Minneapolis, MNThe in-flight collision with geese during approach. The contributing factor was the bright night conditionsNTSB ANC04LA011Accident · No injuriesLimited investigationFinal reportCessna 402 · Galena, AKWater contamination and freezing of the landing gear actuator that prevented the extension of the right main landing gear, resulting in a gear-up landing. Factors contributing to the accident were freezing temperatures at the accident location, and inadequate…NTSB FTW04LA021Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · San Angelo, TXThe pilot's improper weather evaluation and the wrong runway selection. A contributing factor was the tailwind.NTSB FTW04LA020Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Mineral Wells, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB CHI04FA029Accident · Minor injuriesField investigationFinal reportLearjet 24D · Belleville, ILThe total loss of power to the right engine and the partial loss of power to the left engine after the airplane encountered a flock of birds during initial climb out, resulting in impeded ram induction airflow.NTSB LAX04LA041Accident · 2 fatalLimited investigationFinal reportDaughters T18C · Needles, CAthe pilot's continuation of a visual flight rules (VFR) flight into an area of adverse weather, which resulted in an encounter with moderate to severe turbulence and in-flight breakup of the airplane.NTSB LAX04LA039Accident · Serious injuriesLimited investigationFinal reportZivko Edge 540-T · King City, CAThe after market manufacturer's improper application of a crankshaft , which exceeded the original manufacturer's intended use. A factor in the accident was the oil covering the windscreen, which restricted the pilot's ability to see.NTSB CHI04FA031Accident · No injuriesField investigationFinal reportCessna 560XL · Wheeling, ILThe flight crew's intentional operation with know deficiencies in the aircraft and their delay in aborting the takeoff when a no-takeoff warning was presented. An additional cause was the crew's failure to comply with flight manual procedures concerning…NTSB WAS04WA003Accident · No injuriesForeign investigationCessna 172N · Mannheim, GermanyNTSB SEA04LA017Accident · No injuriesLimited investigationFinal reportCessna 150C · Toledo, WAFailure of the main landing gear attachment during the landing roll. An inadequate maintenance modification was a factor.NTSB DEN04LA021Accident · No injuriesLimited investigationFinal reportCessna T210N · Johnstown, COThe pilot's failure to maintain directional control during the landing roll. Factors contributing to the accident were the gusting crosswinds.NTSB DEN04IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe ground personnel’s failure to maintain aircraft clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel, the flight crew's inadequate visual outlook and the parked airplane.NTSB CHI04LA030Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Louisville, KYThe pilot's improper in-flight decision to allow the passenger to manipulate the aircraft flight controls, his failure to maintain altitude/clearance from the river, and his inadequate remedial action. A related factor was the low altitude.NTSB ANC04LA008Accident · No injuriesLimited investigationFinal reportCessna 170B · Manley Hot Sprg, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor contributing to the accident was snow covered terrain at the landing strip.NTSB NYC04LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Wooster, OHThe inadequate visual lookout of the student pilot of the Cessna 150M, which resulted in an on-ground collision with a Cessna 150K that was taking off.NTSB NYC04LA029Accident · No injuriesLimited investigationFinal reportWalters Kolb Mark III · Ashtabula, OHA power loss for undetermined reason(s).NTSB NYC04CA032Accident · Minor injuriesData collectionFinal reportCessna 172N · Philippi, WVThe pilot's improper decision to depart from a runway of insufficient length. Factors in the accident were the turf runway and tailwind condition.NTSB NYC04CA031Accident · No injuriesData collectionFinal reportPiper PA-18 · Westfield, MAThe pilot's failure to maintain aircraft control while landing.NTSB LAX04CA059Accident · No injuriesData collectionFinal reportCessna 172N · Winslow, AZthe pilot's misjudged landing flare, which resulted in a pilot induced porpoise oscillation and hard landing.NTSB ATL04LA035Accident · No injuriesLimited investigationFinal reportCessna 210D · Millington, TNThe malfunction of the main hydraulic landing gear system actuator resulting in an emergency gear up landing.NTSB ANC04LA007Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor contributing to the accident was the presence of deep/soft snow.NTSB SEA04LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Kapowsin, WAThe loss of engine power for undetermined reasons. A contributing factor to the accident was the trees.NTSB NYC04CA028Accident · No injuriesData collectionFinal reportCessna 172K · Kilbourne, OHThe pilot's failure to obtain the proper touchdown point which resulted in an overrun and subsequent nose over.NTSB MIA04WA026Incident · No injuriesForeign investigationPiper PA-46-350P · Walkers Cay, BahamasNTSB MIA04WA021Accident · 1 fatalForeign investigationRobinson R-44 Raven II · Darien, PanamaNTSB MIA04WA020Accident · 2 fatalForeign investigationShort Brothers Skyvan SC7 · Georgetown, GuyanaNTSB LAX04WA040Accident · 4 fatalForeign investigationRobinson R44 · Derby, AustraliaNTSB CHI04LA028Accident · No injuriesLimited investigationFinal reportCessna 175 · Mears, MILoss of engine power due to carburetor icing and the pilot's delayed application of carburetor heat during descent. A factor was the carburetor icing conditions.NTSB NYC04LA027Accident · No injuriesLimited investigationFinal reportBeech M35 · Bellefonte, PAA total loss of engine power during approach for undetermined reasons.NTSB NYC04LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Montauk, NYThe pilot's loss of control after performing an evasive maneuver to avoid a deer crossing the unlit runway, which resulted in a collision with trees. Factors related to the accident were the nighttime conditions, the inoperative runway lighting system, and…NTSB LAX04LA038Accident · 1 fatalLimited investigationFinal reportCathaway RV-6A · Saticoy, CAA loss of engine power due to fuel exhaustion as a result of a loose B-nut fitting for the carburetor fuel inlet line, which allowed fuel to leak out.NTSB ATL04LA034Accident · No injuriesLimited investigationFinal reportHughes 269A · Birmingham, ALThe certified flight instructor's inadequate aircraft control and his improper landing flare resulting in a hard landing and roll over.NTSB ANC04LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's inadequate supervision of the flight, and the student pilot's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over. A factor contributing to the accident was the failure to the student…NTSB SEA04LA015Accident · No injuriesLimited investigationFinal reportSchmitt Exec 162F · Prosser, WAThe student pilot's abrupt application of excessive collective and the flight instructor's inadequate supervision of the student. Contributing factors were the ditch and low rotor RPM.NTSB NYC04LA024Accident · 1 fatalLimited investigationFinal reportCessna 150H · Bruceton Mills, WVThe pilot's physical impairment due to alcohol and his improper decision to attempt flight with a low cloud ceiling, low visibility, after consuming alcohol. A related factor in the accident was the low cloud ceiling.NTSB LAX04FA037Accident · 2 fatalField investigationFinal reportRobinson R22 Beta II · Torrance, CAthe failure of the pilot of the R22 to comply with an ATC clearance.NTSB LAX04CA036Accident · No injuriesData collectionFinal reportR. James Thorne Nieuport 12 · Chandler, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB FTW04LA019Accident · Serious injuriesLimited investigationFinal reportRichard Riley Velocity · Fargo, OKThe pilot's failure to maintain control of the aircraft while practicing slow flight. A contributing factor was the low altitude selected by the pilot.NTSB NYC04IA023Incident · No injuriesIncident investigationFinal reportCessna 208B · Bangor, METhe pilot's inability to see through the windshield, which was obscured due to icing conditions. This resulted in the pilot's inadequate flare, and a subsequent hard landing. A factor contributing to the accident was the wing icing.NTSB FTW04LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Amarillo, TXThe pilot's inadequate compensation for wind condition. Contributing factors were the pilot's lack of total experience in the make and model of aircraft, and the crosswind.NTSB DEN04LA022Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Truth or Conseq, NMthe pilot's inadequate flare and his failure to maintain directional control. A contributing factor was the night light conditions.NTSB LAX04LA035Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B3 · Mesa, AZThe pilot's inadvertent activation of the hydraulic test switch, which resulted in a loss of the hydraulic system pressure, and his failure to maintain directional control.NTSB MIA04WA027Accident · Serious injuriesForeign investigationMitsubishi MU-2B-35 · Bonaire, NT