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 LAX03LA290Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAthe failure of the right main landing gear pivot assembly.NTSB ATL03LA151Accident · Serious injuriesLimited investigationFinal reportSheppard S-2 · Obion, TNThe failure of the elevator control pushrod, that resulted in an uncontrolled descent and subsequent in-flight collision with ground.NTSB SEA03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cle Elum, WAAn undershoot due to the pilot's failure to maintain a proper glide path on final approach to landing. A factor was the gravel.NTSB DEN03FA157Accident · 1 fatalField investigationFinal reportBeech 35 · Belen, NMThe pilot's failure to maintain aircraft control immediately after takeoff due to spatial disorientation. A factor was the dark night light conditions.NTSB CHI03LA324Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Evansville, INThe pilot not maintaining directional control during the landing roll. A contributing factor was the airport sign.NTSB ATL03LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Talladega, ALThe pilot's failure to use carburetor heat when weather conditions were favorable for carburetor icing.NTSB ANC03LA127Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKA loss of engine power for an undetermined reason, which resulted in a forced landing and collision with a runway light fixture.NTSB SEA03LA197Accident · No injuriesLimited investigationFinal reportThompson Avid Flyer · Roche Harbor, WAA complete loss of power due to fuel starvation for undetermined reason(s).NTSB SEA03LA196Accident · Serious injuriesLimited investigationFinal reportBeech T-34 (A-45) · McCall, IDThe inadequacy of the pilot's remedial action taken in an attempt to fly out of an encounter with the wake vortex turbulence created by a preceding aircraft while on short final to land. Factors include calm winds in the area of the final approach course, and…NTSB NYC03CA207Accident · No injuriesData collectionFinal reportRobinson R-22A · Bedford, MAThe certified flight instructor's failure to maintain ground clearance and his delayed remedial action, which resulted in a rollover.NTSB LAX04CA003Accident · Minor injuriesData collectionFinal reportBalloon Works Firefly II · Phoenix, AZthe pilot's diverted attention that resulted in the inadequate handling of the burner during ground operations.NTSB LAX03WA303Accident · 2 fatalForeign investigationRobinson R22 · Derby, AustraliaNTSB FTW03CA233Accident · Minor injuriesData collectionFinal reportHughes 269C · Gail, TXThe loss of control for undetermined reasons.NTSB DCA04WA025Incident · No injuriesForeign investigationBoeing 777-300 · Chennai, IndiaNTSB CHI03LA323Accident · No injuriesLimited investigationFinal reportCessna 150L · Siloam Springs, ARA loss of engine power due to the pilot's inadequate planning/decision resulting in fuel exhaustion. Factors were the trees and the night conditions.NTSB NYC03LA208Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135 · Flushing, NYThe inadequate visual lookout by the driver of a ground vehicle, and by ground support personnel, which resulted in a subsequent collision between the airplane and ground vehicle. A factor related to the accident was the failure of the pilot-in-command and…NTSB NYC03FA206Accident · 2 fatalField investigationFinal reportPiper PA-18-180 · Bardstown, KYThe pilot-in-command's failure to maintain aircraft control for undetermined reasons.NTSB NYC03FA205Accident · 2 fatalField investigationFinal reportCessna 182T · Concord, MAThe pilot's failure to maintain aircraft control due to spatial disorientation. A factor was the low ceilings.NTSB NYC03CA209Accident · No injuriesData collectionFinal reportWells Pitts S1S · Duncannon, PAThe pilot's failure to maintain directional control while landing. Factors were the gusting cross winds.NTSB LAX03LA300Accident · 2 fatalLimited investigationFinal reportMcClanahan Stits Playmate SA-11 · Fontana, CAa loss of engine power due to oil starvation that was the result of misaligned main bearing halves that obstructed the oil galley passages. Since the history of the engine could not be reconstructed, the person or entity responsible for the bearing…NTSB LAX03CA301Accident · No injuriesData collectionFinal reportStarduster SA300 · Quincy, CAthe pilot's failure to maintain directional control of the airplane, which resulted in a ground loop.NTSB CHI03LA322Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Lincoln, NEThe total loss of engine power due to the fatigue fracture of the engine accessory gear drive. A factor was the concrete marker.NTSB ATL03LA150Accident · Minor injuriesLimited investigationFinal reportSherman Holie Freebird · Newnan, GAThe failure of the aileron control rod, and subsequent loss of control in-flight.NTSB ATL03LA149Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Beaufort, NCLoss of engine power due to undetermined reasons.NTSB SEA03CA195Accident · No injuriesData collectionFinal reportCessna 180 H · Council, IDAircraft control not maintained during the landing roll. Factors include soft, water soaked terrain.NTSB FTW03LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Beaumont, TXThe loss of engine power for undetermined reasons.NTSB FTW03LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Houston, TXThe pilot's failure to maintain aircraft control during a landing. A contributing factor was the pilot's diverted attention while performing the after landing check.NTSB DCA03IA058Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Dfw, TXThe improper maintenance of the tailcone evacuation system, which prevented the evacuation slide from inflating during an evacuation due to smoke/fumes in the cabin.NTSB CHI03LA321Accident · No injuriesLimited investigationFinal reportCessna 305A · New Richmond, WIThe pilot's inadequate compensation for wind and his failure to maintain directional control. The pilot's in-flight selection of the wrong runway and excessive application of brake pressure are contributing factors.NTSB CHI03FA320Accident · 1 fatalField investigationFinal reportCessna 152 · Three Oaks, MIThe pilot not maintaining adequate airspeed resulting in a stall during takeoff. Contributing factors were the buzzing flight and trees.NTSB ATL03FA147Accident · 2 fatalField investigationFinal reportGrumman HU-16C · Fort Pierce, FLA loss of engine power due to the pilot placing the fuel selector in the off position which resulted in fuel starvation to the left engine, after the pilot intentionally shut down the right engine.NTSB ANC03LA126Accident · No injuriesLimited investigationFinal reportCessna 170A · Skwentna, AKAn overload failure of the axle retaining nut/bolt assembly, which resulted in the separation of the axle/wheel assembly, and subsequent collapse of the right main landing gear strut during the landing roll.NTSB ANC03LA125Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Cape Yakataga, AKThe pilot's failure to follow the prelanding checklist, which resulted in a wheels up landing when he neglected to lower the airplane's landing gear. A factor in the accident was the pilot's diverted attention associated with turbulence and a wet airstrip.NTSB SEA03LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Bremerton, WAAircraft control was not maintained during the landing roll which resulted in the aircraft nosing over.NTSB NYC03LA204Accident · Serious injuriesLimited investigationFinal reportLaBarge Titan Tornado I · Charlton, MAA seizure of the forward piston during the initial climb.NTSB DEN03LA156Accident · No injuriesLimited investigationFinal reportCessna R182 · Cedar City, UTthe nose wheel separating from the airplane during the precautionary landing. Factors contributing to the accident were the missing nose gear axle through-bolt and the missing cotter pin.NTSB ATL03LA146Accident · Serious injuriesLimited investigationFinal reportAeronca BL-7-AC · Pell City, ALThe pilots failure to maintain airspeed that resulted in the loss of control and the subsequent collision with the ground.NTSB ANC03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nenana, AKThe loss of engine power during cruise flight for an undetermined reason, which resulted in a forced landing and an in-flight collision with trees.NTSB NYC03FA203Accident · 1 fatalField investigationFinal reportCessna 402C · Nantucket, MAThe pilot's failure to maintain aircraft control during a missed approach. Factors in this accident were fog and the night light conditions.NTSB LAX03FA298Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · North Las Vegas, NVthe failure of the Federal Aviation Administration Air Traffic Control Tower local controller and local assist controller to effectively monitor the runway operation and ensure proper separation was maintained between aircraft on intersecting runways.NTSB ANC03LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tanana, AKThe pilot's failure to maintain aircraft control during the landing roll, which resulted in an overrun and nose down. Factors contributing to the accident were gusty winds, and restricted aileron control movement.NTSB LAX03CA299Accident · No injuriesData collectionFinal reportCessna 150F · Reedley, CAthe pilot's failure to maintain the proper glide path and airspeed during final, which resulted in an inadvertent stall/mush.NTSB CHI03LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Versailles, MOThe pilot touched down with excessive airspeed. Factors associated with the accident were the trees, the wet runway, the wet grass that the airplane traveled onto, and the ditch which the airplane contacted.NTSB CHI03LA315Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Chanute, KSThe pilot 's inadequate in-flight planning/decision which resulted in both his in-flight encounter with weather, and the loss of power due to fuel exhaustion. Factors associated with the accident were the night conditions, fog, and the pilot becoming lost and…NTSB ATL03LA144Accident · Minor injuriesLimited investigationFinal reportBeech A90 · Summerville, SCThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB NYC03CA202Accident · Serious injuriesData collectionFinal reportCessna 182B · Spencerport, NYPilot's failure to perform a go-around.NTSB MIA03WA188Accident · No injuriesForeign investigationMaule MX-7-160 · Eleuthera, BahamasNTSB LAX03LA295Accident · No injuriesLimited investigationFinal reportde Havilland DH-8-202 · Phoenix, AZthe ground agent's inadequate visual lookout during push back, which resulted in his failure to maintain clearance between the airplanes.NTSB LAX03LA294Accident · No injuriesLimited investigationFinal reportCessna 172N · Pahrump, NVthe pilot's failure to maintain altitude/clearance from the mountainous terrain while maneuvering, which resulted in an in-flight collision with terrain.NTSB FTW03WA234Accident · No injuriesForeign investigationPiper PA-60 · Pavas, Costa Rica