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 FTW03LA134Accident · No injuriesLimited investigationFinal reportHughes 369HS · Conroe, TXThe pilot's inability to control the helicopter after encountering loss of tail rotor effectiveness. A contributing factor was the unfavorable winds.NTSB ATL03LA080Accident · 1 fatalLimited investigationFinal reportRans S-12 · West Point, TNThe pilot's failure to maintain adequate obstacle clearance which resulted in the inflight collision with a utility line. A factor was utility lines.NTSB ANC03LA045Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dillingham, AKThe pilot's inadequate compensation for wind conditions while taxiing for takeoff, which resulted in a loss of control and an on ground encounter with ocean water. A factor associated with the accident was a gusty wind condition.NTSB LAX03LA138Accident · No injuriesLimited investigationFinal reportEurocopter France AS355N · Redding, CAFailure of the pilot to maintain adequate obstruction clearance during landing, which resulted in the tail rotor contacting a brush pile. The accident sequence was precipitated by the initiation of a precautionary landing by the pilot due to a discrepancy…NTSB FTW03LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Batchelor, LAThe pilot's failure to abort the takeoff with adequate runway available. A contributing factor was the high density altitude.NTSB DEN03LA075Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Salt Lake City, UTthe pilot improperly aligning the airplane on the runway for takeoff. Contributing factors were the reduced visibility due to rain, and the dark night.NTSB SEA03LA076Accident · No injuriesLimited investigationFinal reportFokker F27MK 600 · Port Townsend, WAThe failure of the accessory drive shaft due to deterioration of bearing number 1 in the aft fork of the universal joint for undetermined reasons during cruise flight.NTSB SEA03FA165Accident · 2 fatalField investigationFinal reportCessna 320D · Mazama, WAThe pilot's failure to maintain clearance from terrain while maneuvering. Mountainous terrain, trees and mountain obscuration were factors.NTSB FTW03LA133Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Taft, TXThe partial loss of engine power resulting from a leaking fuel transfer tube following inadequate maintenance by unknown personnel. A contributing factor was the furrowed terrain encountered during the forced landing.NTSB DEN03IA067Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Salt Lake City, UTtotal failure of a fuel flex line. A contributing factor was a fuel leak, resulting in an inflight engine compartment fire.NTSB DEN03FA068Accident · 3 fatalField investigationFinal reportCessna 310D · Provo, UTfailure of the student to maintain aircraft control. Contributing factors were the instructor's inattention to the fuel supply, fuel exhaustion, an inadvertent stall/spin during the turn from base leg to final approach. and the instructor's inadequate…NTSB CHI03IA108Incident · No injuriesIncident investigationFinal reportPiper PA-31T1 · Wheeling, ILThe pilot's failure to maintain obstacle clearance and the inadequate glidepath which resulted in a collision with a utility pole. Contributing factors were the lack of experience in the incident airplane by the left seat pilot, the visual illusion of a…NTSB NYC03LA086Accident · No injuriesLimited investigationFinal reportCessna 182P · Blacksburg, VAThe pilot's improper flare and his improper recovery from a bounced landing.NTSB FTW03LA132Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · DFW Airport, TXAn inadvertent trauma to the passenger's ankle during an emergency evacuation.NTSB DEN03LA076Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Denver, COThe failure of the landing gear system and the flight crew's failure to ascertain that the landing gear was down and locked. A contributing factor was the inadequate maintenance inspections performed by maintenance personnel.NTSB DEN03LA066Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · West Jordan, UTthe dual student's failure to maintain aircraft control and the flight instructor's inadequate supervision of the student. A contributing factor was the unfavorable wind gust.NTSB DEN03LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · St. George, UTthe pilot's improper flare technique, resulting in a hard landing that caused the nose landing gear down-lock to fail and the gear to collapse. A contributing factor was the unfavorable wind.NTSB ANC03LA044Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kotzebue, AKThe pilot's failure to maintain adequate altitude/clearance, which resulted in an in-flight collision with terrain during cruise flight. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB SEA03LA063Accident · No injuriesLimited investigationFinal reportHerb Six Northstar · Medford, ORThe compressive buckling and collapse of the right main landing gear.NTSB NYC03LA085Accident · Minor injuriesLimited investigationFinal reportMcCaa Minimax 1500R · Robbinsville, NJA partial loss of power for undertermined reason(s).NTSB FTW03WA137Accident · 3 fatalForeign investigationGrumman HU-16 · Chetumal, MexicoNTSB FTW03LA129Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Fort Worth, TXA loss of engine power due to corrosion and contamination of the fuel system, and the partially blocked fuel lines and nozzles.NTSB DEN03LA080Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Watkins, COthe pilot's failure to maintain directional control of the aircraft during the landing roll out. Contributing factors were the unlocked tailwheel.NTSB ATL03TA078Accident · Serious injuriesFinal reportAero Commander 500S · Mount Pleasant, SCThe improper refueling of the airplane by airport personnel with the incorrect fuel grade that resulted in a total loss in engine power on both engines during initial climb. A factor was the inadequate preflight inspection by the pilot in command.NTSB ATL03LA079Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75L3 · Gainesville, GAThe pilot's failure to maintain directional control during the landing roll resulting in an inadvertent ground loop.NTSB ANC03LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cantwell, AKThe pilot's selection of an unsuitable landing area in deep snow, which resulted in the nose over of the airplane on touchdown. A factor associated with the accident was a snow-covered airstrip.NTSB MIA03CA095Accident · No injuriesData collectionFinal reportCessna 152 · Olive Branch, MSThe CFI's improper positioning of the fuel selector valve to the off position which resulted in fuel starvation and the subsequent loss of engine power.NTSB LAX03FA135Accident · 3 fatalField investigationFinal reportBeech A36 · Sedona, AZa partial loss of engine power due to the certified flight instructor's failure to comply with the pilot operating handbook requirements for the mixture setting during takeoff. Also causal was the instructor's inadequate supervision of the flight, failure to…NTSB CHI03LA106Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Benson, MNThe loss of engine power for undetermined reasons.NTSB CHI03LA104Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Lino Lakes, MNThe pilot not maintaining aircraft control while manuevering.NTSB SEA03LA062Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air C-4000 · Florence, ORPilot's failure to maintain directional control during the landing roll. Factors include rough terrain.NTSB SEA03LA061Accident · No injuriesLimited investigationFinal reportAvia Stroitel AC-5M · Richland, WAThe pilot's failure to maintain airspeed and the failure of the propeller drive assembly. A factor contributing to the accident was the inadvertent stall.NTSB NYC03LA084Accident · No injuriesLimited investigationFinal reportMaule M4 · Danielson, CTThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB NYC03FA082Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Conesus, NYThe flight instructor's failure to maintain adequate airspeed which resulted in an inadvertent spin.NTSB MIA03LA096Accident · No injuriesLimited investigationFinal reportCessna 172S · Melbourne, FLThe student pilot's improper throttle setting during the braking test, resulting in a collision with a parked airplane.NTSB FTW03WA130Accident · 4 fatalForeign investigationCessna 182L · Esmeralda, VenezuelaNTSB CHI03LA107Accident · No injuriesLimited investigationFinal reportMcBride Avid Flyer · Anderson, INThe pilot's misjudgment of speed which resulted in a landing overrun. The pilot's lack of experience in make and model airplane, and the ditch were contributing factors.NTSB CHI03LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Holt, MOThe pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident were the trees.NTSB SEA03TA060Accident · No injuriesFinal reportMcDonnell Douglas 369E · Plentywood, MTAircraft control was not maintained during a hovering turn. High wind conditions and excessive remedial action were factors.NTSB NYC03LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20K · West Milford, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control. Factors in the accident were the crosswind and landing at night.NTSB LAX03LA136Accident · No injuriesLimited investigationFinal reportCessna 177RG · Redding, CAThe pilot's improper engine starting procedures, and his failure to maintain clearance with a parked airplane, resulting in a collision with the parked and unoccupied airplane.NTSB LAX03FA134Accident · 2 fatalField investigationFinal reportHughes 269B · Auburn, CAthe misjudged flare maneuver by an unknown crewmember during a likely practice autorotation that resulted in an in-flight collision with terrain.NTSB IAD03FA045Accident · 1 fatalField investigationFinal reportBeech A36 · Pomona, NJThe pilot's failure to follow instrument approach procedures. Factors in the accident included the pilot's lack of recent instrument experience and the instrument weather conditions.NTSB CHI03LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Carbondale, ILThe pilot failed to properly recover from a bounced landing which resulted in the airplane porpoising.NTSB CHI03LA102Accident · No injuriesLimited investigationFinal reportCessna 172S · Grayslake, ILThe flight instuctor's improper in-flight decision to land with a tailwind and failure to maintain directional control of the airplane during landing. Factors contributing to the accident were the tailwind, the student pilot's inadequate flare, and the muddy…NTSB ATL03LA076Accident · No injuriesLimited investigationFinal reportLarry Woods Venture · Fort Payne, ALThe pilot's failure to maintain directional control during the landing roll.NTSB MIA03LA098Accident · No injuriesLimited investigationFinal reportCessna 172N · Foxworth, MSThe failure of the pilot to perform a go-around, his failure to attain the proper touchdown point, and his delay in applying the normal brakes resulting in his inability to stop the airplane and subsequent on-ground collision with a fence.NTSB LAX03IA137Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300F4-605R · Oakland, CAthe failure of the 1R evacuation slide to inflate because the transport-locking pin had not been removed from the regulator during the slide's installation on the 1R door. The cause of the cabin/cockpit smoke was contamination of the air conditioning packs.NTSB FTW03WA131Accident · No injuriesForeign investigationBell 407 · Toluca, MexicoNTSB CHI03LA101Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Richmond, INThe pilot misjudged the fuel supply during the aircraft preflight which resulted in fuel exhaustion. A factor associated with the accident was the wires.