NTSB investigations, 2003
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 LAX03LA086Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Oceano, CAthe pilot's failure to maintain directional control of the airplane.NTSB DEN03LA042Accident · No injuriesLimited investigationFinal reportBeech C23 · Pagosa Springs, COthe pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight. Contributing factors were the student pilot's improper flare, the instructor's inadequate remedial actions, and terrain conditions.NTSB ATL03LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182 · LaFayette, GAIn flight loss of engine power for undetermined reasons.NTSB MIA03WA059Accident · 5 fatalForeign investigationPiper PA-60 · Cajamarca, ColombiaNTSB DEN03LA041Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350BII · Vernal, UTThe pilot's inadequate planning resulting in his inattentiveness of the attached longline. Contributing factors were the entanglement of the longline in the tail rotor, failure of the tail rotor drive shaft, and subsequent inability of the pilot to control…NTSB IAD03LA031Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Russellville, KYThe total loss of engine power due to carburetor ice.NTSB ATL03FA041Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Florence, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. A factors was dark night and clouds.NTSB LAX03LA084Accident · Minor injuriesLimited investigationFinal reportCobb International Rotorway Exec 90 · Casa Grande, AZthe flight instructor's failure to maintain directional control of the helicopter during the flare and landing. Factors in the accident were the failure of the secondary drive shaft and inadequate tail rotor failure procedures specified by the manufacturer.NTSB FTW03FA093Accident · 3 fatalField investigationFinal reportCessna T210N · Mission, TXThe pilot's failure to maintain aircraft control, which resulted in his exceeding the airplane's design limitation. Contributing factors were the pilot's decision to fly the airplane with known deficiencies with the attitude indicator, and the failure of the…NTSB CHI03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Halstead, KSFailure by the flight crew to execute an aborted takeoff when acceleration degraded and the improper soft field takeoff procedure as flown by the private pilot. Contributing factors were inadequate supervision by the flight instructor and the tailwind…NTSB CHI03IA066Incident · No injuriesIncident investigationFinal reportBombardier BD 100-1A10 · Wichita, KSThe uninterrupted current overload of the cabin outlet system static inverter leading to ignition and sustained fire. The cause of the initiating overload condition could not be determined. Contributing factors were the lack of adequate current overload…NTSB SEA03LA034Accident · No injuriesLimited investigationFinal reportBeech E18S · Burlington, WAThe pilot's failure to adequately remove ice/frost from the aircraft and to maintain airspeed during the initial climb after takeoff. An inadequate preflight was a factor.NTSB NYC03WA049Accident · No injuriesForeign investigationCessna 188B · Badger, Nfld, CanadaNTSB LAX03LA082Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Middletown, CAThe pilot's failure to attain an adequate takeoff airspeed and failure to abort the takeoff when the lack of acceleration was apparent.NTSB FTW03LA094Accident · No injuriesLimited investigationFinal reportCessna 210L · Morrilton, ARThe failure of the main landing gear to extend and lock, as a result of a hydraulic fluid leak caused by a chaffed and ruptured flex line.NTSB IAD03LA030Accident · Minor injuriesLimited investigationFinal reportYoung Challenger II · Huntington, WVThe pilot's improper decision to switch off the ignition on approach and not attaining the proper touchdown point.NTSB FTW03LA092Accident · Minor injuriesLimited investigationFinal reportMooney M20J · New Orleans, LAThe loss of engine power as a result of the separation of the magneto assembly due to inadequate maintenance by unknown personnel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Waskish, MNThe inadequate preflight planning/preparation by the pilot. Contributing factors were the snow covered takeoff area and the tailwind.NTSB SEA03LA032Accident · No injuriesLimited investigationFinal reportCessna 180 B · Klamath Falls, ORFailure to adequately compensate for wind conditions while landing.NTSB ATL03LA040Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Titusville, FLThe loss of engine power for undetermined reasons. The pilot's failure to attain full power for takeoff in accordance with the operation handbook was a factor.NTSB SEA03WA033Accident · No injuriesForeign investigationBoeing 737-400 · Vancouver, BC, CanadaNTSB SEA03LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prosser, WAImproper flare while landing. Factors include rough uneven terrain.NTSB LAX03LA081Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Long Beach, CAThe pilot's excessive pull up, which resulted in a failure to obtain/maintain flying speed and a subsequent stall/mush.NTSB LAX03LA080Accident · No injuriesLimited investigationFinal reportBeech S-35 · Quartzsite, AZThe driver of the vehicle did not stop prior to crossing the airstrip as directed by airstrip signage.NTSB LAX03LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tehachapi, CAThe pilot's failure to maintain adequate clearance above the surrounding terrain, and his evasive maneuver to avoid a perceived object. A factor in the accident was the dark night.NTSB FTW03LA091Accident · No injuriesLimited investigationFinal reportGilbertson Zodiac CH601HDS · Grandfield, OKThe loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the unfavorable wind.NTSB CHI03LA063Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot's failure to maintain aircraft control which resulted in the overload of the aircraft. Spatial disorientation, an inoperative turn coordinator, and the pilot's misinterpretation of the flight instruments were contributing factors.NTSB ATL03LA039Accident · No injuriesLimited investigationFinal reportRobinson R22 · Fort Lauderdale, FLThe private pilots improper use of flight controls during a run on landing resulting in a roll over.NTSB ANC03LA025Accident · No injuriesLimited investigationFinal reportCessna 150 · Kenai, AKThe pilot's delayed application of the airplane brakes resulting in an overrun during the landing roll, and subsequent collision with a snowbank. A contributing factor in the accident was icy runway conditions.NTSB MIA03FA050Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA300/L · Golden Gate, FLThe airplane's entry into a near vertical descent for undetermined reasons, which resulted in a collision with terrain during the resultant descent.NTSB LAX03FA078Accident · 2 fatalField investigationFinal reportBeech D95A · Lancaster, CAa loss of aircraft control due to the instructor pilot's incapacitation by seizure activity as a result of his undiagnosed cancer, and his use of a medication that can increase seizure risk.NTSB FTW03LA096Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Wildorado, TXThe airplane collided with an animal that wandered onto the runway. A contributing factor was sun glare impairing the pilot's view on final approach.NTSB CHI03LA062Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Plains, MOThe excessive descent rate that required an abrupt flare, resulting in the main rotor severing the tailboom.NTSB CHI03LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeville, MNThe pilot's inadequate removal of ice and snow during the airplane preflight, and the subsequent loss of control due to the airplane being covered with ice.NTSB ATL03LA038Accident · No injuriesLimited investigationFinal reportBeech 200 · Jackson, MSThe failure of the landing gear system for undetermined reasons.NTSB DEN03FA040Accident · 1 fatalField investigationFinal reportBeech V35B · Rock Springs, WYthe pilot's failure to maintain adequate airspeed, resulting in a stall. Factors contributing to the accident were the icing conditions, low altitude, and the high gusting winds.NTSB ANC03LA030Accident · No injuriesLimited investigationFinal reportCessna 208B · Russian Mission, AKThe failure of the pilot to use a tail stand while loading passengers, which resulted in the airplane's tail impacting the ground.NTSB DEN03LA039Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Logan, NMthe pilot's improper in-flight planning/decision, his failure to accomplish appropriate checklist items during the go-around, and his failure to maintain clearance from the trees and the lamp post. Factors contributing to the accident were the low altitude,…NTSB CHI03FA060Accident · 1 fatalField investigationFinal reportAgusta A109C · West Chicago, ILThe pilot's failure to maintain control of the helicopter while maneuvering, resulting in the excessive descent rate and impact with terrain. Factors to the accident included the dark night, low ceiling and reduced visibility at the time of the accident.NTSB SEA03LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAAircraft control was not maintained during the landing roll. A tailwind and a snow bank were factors.NTSB NYC03LA046Accident · 1 fatalLimited investigationFinal reportMitsubishi MU-2B-60 · Cleveland, OHthe bank couriers inadequate visual lookout, as he approached an airplane with operating engines. A factor was the lack of guidance and training from the bank, for working around airplanes with operating engines.NTSB MIA03LA049Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Myrtle Beach, SCA loss of engine power for undetermined reasons.NTSB MIA03LA048Accident · No injuriesLimited investigationFinal reportCessna 172F · Jacksonville, FLa total loss of engine power due to the failure the oil filter because of over-pressurization, resulting in damage to the airplane during the subsequent forced landing.NTSB LAX03FA076Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Scottsdale, AZthe pilot's failure to maintain an adequate altitude clearance from mountainous terrain. Contributing factors were dark night conditions, mountainous terrain, and the pilot's diverted attention.NTSB NYC03LA044Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Newport, METhe fatigue failure of a the cylinder wall.NTSB NYC03FA043Accident · 2 fatalField investigationFinal reportBeech V35B · Delaware City, DEThe mechanic's improper engine overhaul. A factor was the night condition.NTSB MIA03FA046Accident · 4 fatalField investigationFinal reportCessna M337B (O-2A) · Fernandina Bch, FLThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent collision with the ocean.NTSB MIA03CA053Accident · No injuriesData collectionFinal reportCessna 182R · Everglades City, FLstudent pilot's improper use of the brakes at the landing touchdown which caused the left main landing gear tire to burst, resulting in the student and certified flight instructor pilots not being able to maintain control of the airplane, and the subsequent…NTSB DEN03LA037Accident · Minor injuriesLimited investigationFinal reportRothrock Cozy Mark IV · Erie, COThe pilot's failure to maintain aircraft control during landing. Contributing factors were the high crosswinds and the gusts.NTSB DCA03WA027Accident · No injuriesForeign investigationBoeing 737-2M9 · Rio Branco, Brazil