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 MIA03FA071Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Cedar Key, FLThe pilot's inadequate in-flight planning/decision by his continued VFR flight into instrument meteorological condition after receiving an in-flight weather advisory. Also causal was his failure to maintain aircraft control, which resulted in flight that…NTSB ATL03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rogersville, TNThe pilot's improper landing flare which resulted in a hard landing.NTSB NYC03FA061Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Monterey, MAThe pilot's improper decision to attempt a visual flight rules (VFR) flight in marginal VFR weather conditions over mountainous terrain, which resulted in an in-flight collision with trees. Factors in this accident were clouds and night light conditions.NTSB LAX03LA105Accident · Serious injuriesLimited investigationFinal reportAero Commander 690A · Tracy, CAthe failure of the pilot to maintain directional control during the departure roll on a narrow runway. A factor in the accident was the pilot's limited experience in the airplane.NTSB LAX03LA104Accident · No injuriesLimited investigationFinal reportTowner Kit Fox 4 · Glendale, AZthe propeller's separation in-flight as a result of a bird strike.NTSB DEN03LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Gateway, COthe pilot's failure to maintain aircraft control. Contributing factors were the snow-covered runway.NTSB SEA03LA044Accident · No injuriesLimited investigationFinal reportCessna 180 A · Malin, ORAircraft control not maintained during landing. Soft terrain was a factor.NTSB MIA03LA072Accident · Serious injuriesLimited investigationFinal reportMooney M20M · Destin, FLThe inadequate annual/100-hour inspection of the engine by the mechanic for his failure to properly secure the tailpipe assembly to the turbocharger resulting in separation of the tailpipe and subsequent in-flight fire. Contributing factors in the accident…NTSB FTW03LA102Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Ruston, LAThe separation of the upper tail cone as a result of a fractured bolt due to fatigue.NTSB ATL03FA052Accident · 5 fatalField investigationFinal reportBeech BE-36A · Mount Airy, NCThe pilots failure to maintain control of the aircraft due to spatial disorientation. A factor was low clouds.NTSB ANC03LA029Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain altitude/clearance above the ground, resulting in a collision with snow and ice covered terrain during the final approach phase of a VFR landing. Factors…NTSB NYC03LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Westerly, RIThe pilot-in-command's delayed remedial action when the airplane flew below the glidepath, and a total loss of engine power for undetermined reasons.NTSB LAX03LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZthe CFI's inadequate supervision and delayed decision to abort the takeoff resulted in the runway overrun.NTSB IAD03FA035Accident · 3 fatalField investigationFinal reportSocata TBM 700 · Leesburg, VAThe pilot's failure to fly a stabilized, published instrument approach procedure, and his failure to maintain adequate airspeed which led to an aerodynamic stall.NTSB ENG03RA009Incident · No injuriesForeign investigationCessna Conquest · Lake Johnston, AustraliaNTSB CHI03LA076Accident · Minor injuriesLimited investigationFinal reportCessna T210L · New Hudson, MIThe pilot's failure to maintain aircraft control which resulted in the airplane stalling while on final approach.NTSB ATL03LA051Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Atlanta, GAThe flight's encounter with severe turbulence that resulted in serious injury to a flight attendant.NTSB ATL03LA050Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenwood, SCThe pilot's continued visual flight into instrument meteorological conditions and loss of aircraft control, which resulted in an in-flight collision with the ground.NTSB ANC03IA037Incident · No injuriesIncident investigationFinal reportCessna 206 · Homer, AKThe separation of the main landing gear spring strut during landing touchdown due to corrosion and fatigue. Factors contributing to the accident were the manufacturer's and the FAA's insufficient standards/requirements for inspection procedures.NTSB NYC03LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe student pilot's misjudgment of distance/altitude and the instructor's delayed remedial action,NTSB NYC03FA058Accident · 1 fatalField investigationFinal reportCessna 182G · Renfrew, PAThe pilot's failure to maintain control of the airplane while maneuvering to land. Factors in the accident were the pilot's decision to fly into forecasted\known icing conditions, and the accumulation of structural ice.NTSB MIA03FA068Accident · 1 fatalField investigationFinal reportBeech 36 · Captiva Island, FLThe pilot's VFR flight into instrument meteorological conditions and his ensuing failure to maintain altitude/clearance resulting in an in-flight collision with the ocean. A factor was the fog.NTSB LAX03LA101Accident · No injuriesLimited investigationFinal reportCreitz, Robert D RV-3 · Deer Valley, AZThe pilot's improper use of carburetor heat, which resulted in carburetor icing and loss of engine power.NTSB LAX03FA102Accident · 2 fatalField investigationFinal reportMitchell CH-801 · Nicholas, CAan in-flight structural failure due to the pilot exceeding the design limitations of the airplane. Drug impairment was a factor.NTSB FTW03WA103Accident · 1 fatalForeign investigationCessna 411 · Colchani, BoliviaNTSB CHI03LA112Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Grand Rapids, MNThe pilot's failure to obtain adequate airspeed which resulted in a stall. The short, soft, takeoff area, and the trees were contributing factors.NTSB NYC03WA057Accident · No injuriesForeign investigationAerospatiale Concorde · Jamaica, NYNTSB NYC03LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Cincinnati, OHThe student pilot's failure to maintain directional control.NTSB NYC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Blue Bell, PAThe pilot's failure to maintain directional control after a loss of engine power for undetermined reasons.NTSB ATL03FA049Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Sylvania, GAThe pilot's decision to conduct VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Related factors were the guy wire and the fog.NTSB MIA03LA067Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Miami, FLThe flight crew's inadvertent encounter with turbulence while attempting to maneuver through an area of convective activity during descent.NTSB MIA03FA066Accident · 1 fatalField investigationFinal reportCessna 172P · Osteen, FLThe intentional suicidal act by the pilot-in-command resulting in the in-flight collision with trees then the ground.NTSB LAX03LA097Accident · 1 fatalLimited investigationFinal reportFirefly 11B · Yountville, CAA bystander was impaired by drugs and did not follow the pilot's directive to release the balloon as it began its ascent.NTSB IAD03LA034Accident · No injuriesLimited investigationFinal reportCessna 150J · Williamson, NYThe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor was the snow-covered runway.NTSB SEA03FA041Accident · 2 fatalField investigationFinal reportGrubert KIS TRI-R TR-1 · Puyallup, WAThe pilot-in-command's failure to maintain adequate flying airspeed during the turn from crosswind to downwind resulting in an inadvertent stall/spin and subsequent collision with terrain (ground).NTSB MIA03LA070Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe intentional cutting of the hydraulic line by an unknown person resulting in the loss of hydraulic fluid and the inability of the pilot-in-command to extend and lock the main landing gear, and subsequent collapse of the main landing gear after touchdown.NTSB LAX03LA096Accident · No injuriesLimited investigationFinal reportCessna 310 · Palmdale, CAThe pilot's failure to maintain an adequate terrain/obstacle clearance altitude. Factors in the accident were the low ceilings and the dusk light illumination.NTSB LAX03LA094Accident · No injuriesLimited investigationFinal reportLuscombe T-8F · El Cajon, CAThe pilot's inadequate compensation for the crosswind conditions and loss of directional control during landing.NTSB LAX03FA100Accident · 2 fatalField investigationFinal reportCessna 172N · Ely, NVthe pilot's failure to maintain adequate terrain clearance while flying in a box canyon.NTSB NYC03LA054Accident · 1 fatalLimited investigationFinal reportCessna 182P · So. Charleston, WVThe pilot's failure to perform a go-around prior to touchdown. Factors in the accident were the rising terrain and tail wind.NTSB LAX03LA095Accident · No injuriesLimited investigationFinal reportAerostar RX-7 · Reno, NVA sudden wind shift that forced the balloon to drift towards an obstruction, and the pilot's inability to perform an evasive maneuver in sufficient time to prevent a collision.NTSB LAX03LA092Accident · 1 fatalLimited investigationFinal reportEverett BD-10 · Dana Point, CAin-flight breakup of the experimental airplane for undetermined reasons.NTSB LAX03FA093Accident · 2 fatalField investigationFinal reportPiper PA-30 · Nipomo, CAthe flying pilot's failure to maintain an adequate airspeed that resulted in a stall/spin.NTSB FTW03LA101Accident · 1 fatalLimited investigationFinal reportBell 407 · High Island 443The pilot's failure to maintain directional control of the helicopter during the hot refueling operation which resulted in the main rotor blades striking the passenger. A contributing factor was the high wind conditions.NTSB ATL03LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Rome, GAThe maintenance personnel failure to secure the throttle linkage during the installation of the carburetor that resulted in the loss of engine power.NTSB MIA03LA069Accident · No injuriesLimited investigationFinal reportBeech A45 · Merritt Island, FLThe separation of both propeller blades in-flight for undetermined reasons and the failure of the pilot to attain the proper touchdown during the forced landing resulting in overrun during landing and subsequent collapse of the nose landing gear. A…NTSB LAX03LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZthe student pilot's inadequate compensation for the existing crosswind conditions and failure to maintain directional control during the touch-and-go takeoff. A factor was his improper use of (failure to reduce) the throttle and normal brakes during the…NTSB SEA03LA040Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Garryowen, MTThe pilot in command's allowing the aircraft to inadvertently enter into a stall condition at low altitude while maneuvering. A contributing factor was the pilot's intentional low altitude maneuvering.NTSB NYC03LA053Accident · No injuriesLimited investigationFinal reportCessna 180 · East Windsor, CTThe pilot's failure to maintain directional control. A related factor was the snow-covered runway conditions.NTSB MIA03LA064Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Marathon, FLThe loss of engine power to both engines for undetermined reasons.