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 FTW03WA226Accident · 8 fatalForeign investigationCessna 402B · Tecalitran, MexicoNTSB ATL03FA137Accident · 1 fatalField investigationFinal reportMooney M-20C · Monticello, GAThe pilot's continued VFR flight into IMC conditions, and his failure to maintain obstacle clearance and collision with trees. A factor was low ceiling.NTSB SEA03LA189Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Diamond, ORLoss of engine power for undetermined reasons during hover.NTSB NYC03LA199Accident · 1 fatalLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Norfolk, VAthe airline ground person's failure to properly control the pushback tug, and her subsequent failure to maintain adequate clearance between the tug and the airplane. Factors contributing to the accident were the airline ground person's operation of the tug…NTSB FTW03LA224Accident · Minor injuriesLimited investigationFinal reportBell 206-B3 · Galveston 395The reason for loss of control was undetermined.NTSB FTW03LA223Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Farwell, TXThe pilot's failure to maintain airspeed while maneuvering which resulted in an inadvertent stall.NTSB DCA03WA056Accident · 9 fatalForeign investigationBeech King Air B200 · Madeira Islands, PortugalNTSB CHI03LA310Accident · No injuriesLimited investigationFinal reportCessna 182D · Rushville, INThe pilot failed to maintain control of the airplane during the initial takeoff climb which resulted in an inadvertent stall.NTSB MIA03LA181Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C-1 · Homestead, FLthe inadequate 100-hour inspection of the helicopter by other maintenance personnel who failed to discover that the landing gear dampers had low pressure, which resulted in ground resonance and subsequent substantial damage during a run-on landing.NTSB FTW03LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ardmore, OKThe failure of the pilot to adequately compensate for existing wind conditions. A contributing factor was the gusty crosswind conditions from the east.NTSB CHI03LA309Accident · Minor injuriesLimited investigationFinal reportStrother KR2 · Clarinda, IAFailure of the pilot to maintain clearance from the roadway sign. The loose gravel and the sign were contributing factors.NTSB ANC03LA113Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Chalkyitsik, AKThe pilot's inadequate compensation for wind conditions, and his failure to maintain adequate airspeed during takeoff, which resulted in an in-flight collision with brush, and subsequent stall of the airplane. Factors associated with the accident were a…NTSB ANC03LA112Accident · No injuriesLimited investigationFinal reportDusseau Kitfox · Nikiski, AKA loss of engine power for an undetermined reason, which resulted in an overrun during the emergency landing, and subsequent nose over in swampy terrain.NTSB SEA03LA188Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Billings, MTThe pilot's inadequate compensation for wind conditions which led to a loss of control and subsequent ground loop. A contributing factor was the wind gust.NTSB MIA03LA180Accident · No injuriesLimited investigationFinal reportPiper J5A · Winter Haven, FLThe inadequate preflight of the airplane by the pilot-in-command, which failed to detect water-contaminated fuel, and his failure to maintain airspeed resulting in an inadvertent stall.NTSB FTW03LA222Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Porter, TXThe pilot's inadequate compensation for wind conditions and his failure to maintain control of the airplane while landing. A contributing factor was the gusty winds.NTSB CHI03LA317Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Highland, ILThe pilot encountering unsuitable terrain during an off-airport landing. A factor to the accident was the high vegetation.NTSB NYC03LA198Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Rockford, OHThe pilot's failure to maintain the proper altitude/clearance, which resulted in an in-flight collision with a utility wire. The owner's improper decision to allow the airplane to be operated by an uncertificated pilot was also causal.NTSB MIA03LA179Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLA loss of engine power due to inadequate maintenance.NTSB LAX03LA297Accident · No injuriesLimited investigationFinal reportEurocopter France AS 350 BA · Hilo, HIthe pilot's inadvertent encounter with instrument meteorological conditions and his failure to maintain aircraft control. Contributing factors were fog, rough/uneven terrain, and spatial disorientation.NTSB LAX03LA283Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Monterey, CAThe pilot’s inadequate in-flight planning/decision, which resulted in a loss of engine power during an instrument approach to land, and an in-flight collision with a tree and terrain.NTSB LAX03CA284Accident · No injuriesData collectionFinal reportHiller UH12E · Kekaha, HIthe pilot's failure to maintain clearance with the wires due to an inadequate visual lookout.NTSB FTW03LA216Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Kisatchie, LAA loss of engine power due to water contamination in the fuel system.NTSB CHI03LA311Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Cash, ARThe delayed aborted takeoff by the pilot. The ditch was a factor to the accident.NTSB CHI03LA305Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Pine River, MNAn inadequate pre-flight inspection by the pilot due to his failure to visually confirm fuel quantity prior to flight, and the resulting fuel exhaustion. Contributing factors were the pilot's improper use of the fuel management computer installed in the…NTSB FTW03LA219Accident · No injuriesLimited investigationFinal reportCessna 150F · Knox City, TXThe student pilot's inadequate flight planning/decision, resulting in fuel exhaustion and the loss of engine power. Contributing factors were the student pilot's failure to refuel the airplane and lack of suitable terrain for the forced landing.NTSB CHI03LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wausau, WIThe excessive free play resulting in a loose tail wheel assembly and a failure of the flight crew to maintain directional control during the landing rollout.NTSB CHI03LA304Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Atwood, ILThe pilot's failure to correctly identify the location of the airport. Factors to the accident include the pilot flying while fatigued, which contributed to his misidentification of the runway, and the rough/uneven soybean field.NTSB ANC03LA111Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-160 · Skwentna, AKThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent in-flight collision with terrain. A factor associated with the accident was a downdraft.NTSB NYC03LA196Accident · Minor injuriesLimited investigationFinal reportCessna 180D · Greenville, METhe inadequate installation and inspection of an aileron cable by maintenance personnel, which resulted in a loss of control in-flight and subsequent collision with water.NTSB NYC03CA193Accident · No injuriesData collectionFinal reportCessna 150M · Jetersville, VAThe pilot's delayed decision to abort the takeoff, which resulted in an overrun. A factor was the dew on the grass.NTSB NYC03CA192Accident · No injuriesData collectionFinal reportCessna 152 · Franklin, VAThe student pilot's improper flare, which resulted in a hard landing.NTSB LAX03LA280Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Sacramento, CAthe pilot's inadequate preflight inspection and the bystander's failure to maintain clearance with the rotating propeller.NTSB DEN03LA151Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Taos, NMthe pilot's failure to maintain directional control during landing roll which resulted in the subsequent ground loop/swerve and impact with the ditch.NTSB DEN03LA150Accident · No injuriesLimited investigationFinal reportCessna 182A · Pine Haven, WYThe loss of engine power for undetermined reasons. The lack of suitable terrain is a contributing factor.NTSB CHI03LA303Accident · No injuriesLimited investigationFinal reportCessna 172G · Greenville, MIThe pilot's inadequate takeoff procedure with the use of 20 degrees of flaps. Contributing factors were the interrelated effects of high aircraft weight, the density altitude, and the relative humidity. An additional factor was the trees.NTSB CHI03FA301Accident · 1 fatalField investigationFinal reportAeronca 11BC · Colfax, WIThe pilot failed to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall. A factor associated with the accident was the low altitude at which the pilot was maneuvering.NTSB ANC03CA110Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Eagle, AKThe pilot's selection of an unsuitable landing area, and his excessive use of the airplane's brakes during the landing roll, resulting in a nose over. A factor associated with the accident was rough and uneven terrain.NTSB SEA03LA187Accident · No injuriesLimited investigationFinal reportCessna 172RG · Blanchard, IDThe loss of engine oil as a result of the inadequate installation of the idler gear shaft set screw and the lack of a safety wire on the hex head (oil) plug. A contributing factor was the rough and uneven terrain.NTSB NYC03CA194Accident · Minor injuriesData collectionFinal reportunknown Avid Flyer · Covington, NYThe pilot's failure to abort the takeoff.NTSB LAX03CA279Accident · No injuriesData collectionFinal reportBell 206B · Long Beach, CAthe pilot's inadequate remedial action in response to a loss of tail rotor effectiveness.NTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB DEN03LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Farmington, NMthe pilot's improper procedures/directives, and the delayed activation of carburetor heat which resulted in the loss of engine power and subsequent impact with terrain. Contributing factors include the carburetor icing conditions, and the rough/uneven and…NTSB CHI03LA318Accident · Minor injuriesLimited investigationFinal reportDixon Glasair II · Columbia, ILThe pilot's failure to maintain directional control during an aborted takeoff. Contributing factors were the open cabin door, the grass runway and the soft terrain adjacent to the runway.NTSB CHI03LA306Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Moline, ILThe partial failure of the engine driven fuel pump and fuel starvation. An additional cause was the pilot misjudging the proper glidepath and his improper in-flight decision during the precautionary landing to pull back the power and lower the flaps prior to…NTSB CHI03LA302Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Sikeston, MOThe pilot's inadvertent activation of the brake system during touchdown and his inadequate remedial action, which resulted in the airplane nosing over.NTSB ATL03FA136Accident · 1 fatalField investigationFinal reportBeech BE-55 · Winder, GAThe pilot's inadequate preflight preparation in which he failed to secure the cabin door which diverted his attention and resulted in the failure to maintain directional control.NTSB ANC03LA120Accident · No injuriesLimited investigationFinal reportCessna 150 · Tanana, AKThe pilot's failure to abort the takeoff after encountering muddy terrain during the takeoff roll, which resulted in a runway overrun and collision with trees. A factor in the accident was the muddy runway.NTSB ANC03CA109Accident · No injuriesData collectionFinal reportMaule M-6-235 · Kenai, AKThe pilot's failure to maintain adequate altitude/clearance during an intentional go-around, which resulted in an in-flight collision with trees.NTSB NYC03LA195Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJThe pilot's delay in executing a go-around, which resulted in an encounter with wake turbulence from a helicopter. A factor in the accident was the wake turbulence.