NTSB investigations, 2002
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 2002 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") = 2002 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 LAX02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Santa Clarita, CAThe pilot performed inadequate planning and inaccurate fuel computations, and intiated flight without refueling. This resulted in a forced landing on a road at night due to fuel exhaustion.NTSB LAX02FA110Accident · 1 fatalField investigationFinal reportPilatus UV-20A · Marana, AZthe failure of both pilots to maintain an adequate visual lookout. The failure of the Pilatus pilot to report his proper position was a factor.NTSB DEN02LA038Accident · No injuriesLimited investigationFinal reportCessna T337D · St. George, UTthe pilot's misjudged landing flare, which resulted in an inadvertent stall/mush and a hard landing.NTSB CHI02FA093Accident · 1 fatalField investigationFinal reportCessna 208B · Alma, WIThe pilot not removing the ice contamination from the airplane prior to departure and the pilot intentionally flying into known severe icing conditions, resulting in the aircraft not being able to maintain altitude/clearance from the terrain. Factors to the…NTSB SEA02LA054Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Rainier, WAThe pilot's failure to maintain the proper decent rate on approach. A factor was the trees in close proximity to the airport.NTSB MIA02FA067Accident · 1 fatalField investigationFinal reportPiper PA32R-300 · Broadway, NCThe pilot's inadequate visual lookout and his failure to maintain obstacle clearance.NTSB LAX02FA108Accident · Serious injuriesField investigationFinal reportBeech E90 · Reno, NVThe pilot's inadequate approach airspeed for the existing adverse meteorological conditions followed by his delayed remedial action to avert stalling and subsequent loss of airplane control. Contributing factors were the pilot's reduced visibility due to the…NTSB FTW02LA094Accident · No injuriesLimited investigationFinal reportCessna 402C · Albuquerque, NMThe failure of the tug driver to stop at the stop sign resulting in a collision with a taxiing airplane. A contributing factor was the dark night light conditions.NTSB FTW02IA097Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Tulsa, OKThe failure of the horizontal stabilizer control system for undetermined reasons.NTSB CHI02LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Christopher, ILThe in-flight collision with a Canadian goose, which caused substantial damage to the airplane's right wing. A factor to the accident was the dark night light condition.NTSB ATL02IA065Incident · No injuriesIncident investigationFinal reportBeech C24R · Greenville, MSAn overload failure of the nose gear assembly for undetermined reasons.NTSB FTW02LA093Accident · No injuriesLimited investigationFinal reportTillman Long EZ · Lockhart, TXthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02FA095Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Marianna, ARThe pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain while maneuvering. Factors were, the low cloud and mist weather conditions, and the dark night light conditions.NTSB CHI02LA091Accident · Minor injuriesLimited investigationFinal reportAviat Pitts S-2B · Milwaukee, WIThe loss of engine power for undetermined reasons. A factor in the accident was the telephone pole.NTSB CHI02LA090Accident · No injuriesLimited investigationFinal reportCessna 182J · Springfield, ILThe pilot not maintaining clearance from a fence while taxiing. The fence was a factor.NTSB ANC02LA022Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fairbanks, AKThe pilot's failure to complete his prelanding checklist, and a subsequent inadvertent wheels up landing.NTSB SEA02GA053Accident · 3 fatalFinal reportPiper PA-31 · Atlanta, IDThe pilot's failure to maintain aircraft control while in cruise flight which resulted in the in-flight separation due to overload of the spar at the right wing root. Hypoxia was a factor.NTSB FTW02LA092Accident · Minor injuriesLimited investigationFinal reportSchleicher AS-W19 · Moriarty, NMThe pilot's attempt to perform a turn upwind at a altitude too low to complete the turn. A factor was the turbulance.NTSB FTW02LA091Accident · No injuriesLimited investigationFinal reportCessna 402C · Albuquerque, NMThe failure of the left main landing gear scissors assembly which resulted from improper maintenance.NTSB WAS02WA027Accident · No injuriesForeign investigationSikorsky S-76C+ · Blackbushe, United KingdomNTSB DEN02FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Glenwood Sprngs, COthe pilot's failure to maintain aircraft control due to spatial disorientation, resulting in a collision with terrain. Contributing factors were the pilot's lack of an instrument rating and the dark night conditions.NTSB LAX02LA106Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZthe pilot's misjudged landing flare and improper bounced landing recovery.NTSB IAD02LA036Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Strausburg, VAThe pilot's inadequate evaluation of weather resulted in a loss of thermal lift, which resulted in an impact with trees.NTSB DEN02LA031Accident · No injuriesLimited investigationFinal reportDoyle Kitfox III · Windsor, COloss of engine power due to restricted fuel flow for reasons undetermined. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB SEA02LA052Accident · No injuriesLimited investigationFinal reportSkystar Kitfox Lite Squared · Caldwell, IDThe pilot's failure to adequately compensate for the wind conditions. High and gusting winds were a factor.NTSB NYC02FA068Accident · 1 fatalField investigationFinal reportCessna T210N · Teterboro, NJImproper maintenance by other maintenance personnel, which resulted in the air filter element being sucked into and blocking the turbocharger inlet, and a subsequent power loss. Factors in the accident were the pilot's failure to maintain airspeed and the…NTSB DCA02MA026Accident · No injuriesMajor investigationFinal reportCanadair CL-600-2B19 · Dulles Airport, VAthe airplane's collision with two wild turkeys.NTSB ATL02FA063Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Laurens, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with terrain. Factors were low clouds and dark-night.NTSB ATL02FA062Accident · 2 fatalField investigationFinal reportEurocopter France AS355 F1 · Savannah, GAThe pilot's failure to follow operating procedures and, experienced spatial disorientation while attempting a night landing to an offshore platform. A factor was a dark night.NTSB SEA02LA051Accident · No injuriesLimited investigationFinal reportBell/Garlick UH-1H · Dayton, WAA loss of power for undetermined reason(s). Contributing factors were the pilot's delayed decision to jettison the empty bucket and the trees impacted during the auto-rotation landing.NTSB NYC02LA069Accident · No injuriesLimited investigationFinal reportPiper P46T · Philadelphia, PAThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to flare during initial touchdown.NTSB LAX02TA105Accident · No injuriesFinal reportPiper PA-18-150 · Winnemucca, NVThe pilot's inadequate fuel consumption calculations that lead to fuel exhaustion.NTSB CHI02LA087Accident · No injuriesLimited investigationFinal reportCessna 182H · West Plains, MOThe engine failure due to the fatigue fracture of the crankshaft which resulted from the installation of improper pistons during an STC'd engine conversion by other maintenance personnel. Additional factors included the unsuitable terrain encountered by the…NTSB CHI02FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Niles, MIFlight into known adverse weather conditions by the pilot and the spatial disorientation of pilot. Contributing factors were the lack of certification by the pilot and the weather conditions.NTSB ATL02LA061Accident · 1 fatalLimited investigationFinal reportMoore Sammie M-Breezy · Pell City, ALThe pilot's failure to maintain flying speed, followed by an inadvertent stall spin, and subsequent collision with terrain.NTSB MIA02LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Kissimmee, FLThe pilot's failure to maintain the proper clearance while taxing the airplane which resulted in the left wing tip colliding with an object and damage to the airplane. A related factor was night conditions.NTSB LAX02LA125Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Dixon, CAThe pilot lost directional control due to the unsuitable landing area. A contributing factor was the muddy runway condition.NTSB LAX02LA104Accident · No injuriesLimited investigationFinal reportCessna 172L · Bullhead City, AZThe pilot's failure to comply with maintenance/inspection requirements that resulted in a propeller failure.NTSB LAX02LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Coalinga, CAthe pilot's failure to maintain directional control and his inadequate compensation for the wind conditions. The crosswind was a contributing factor.NTSB SEA02LA050Accident · No injuriesLimited investigationFinal reportUnander Velocity 173RG · West Jordan, UTThe pilot's failure to ensure that the gear was extended prior to landing. Factors included a failure of a hydraulic down-pressure switch, and the pilot's attention diverted to another aircraft executing an opposite-direction traffic pattern.NTSB MIA02FA066Accident · 2 fatalField investigationFinal reportCessna 172N · Bunnell, FLInadequate maintenance inspection of the airplane by comapny maintenance personnel which resulted in corrosion in an aileron control cable going undetected, failure of the aileron control cable, and impact with terrain following loss of control of the…NTSB LAX02FA101Accident · 3 fatalField investigationFinal reportCessna 425 · San Jose, CAthe pilot's loss of control and resulting exceedence of the design stress limits of the aircraft, which led to an in-flight structural failure. The pilot's loss of control was due in part to the loss of primary airspeed reference resulting from pitot tube…NTSB FTW02LA090Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Melbourne, ARthe pilot's failure to maintain directional control as a result of becoming incapacitated due to a stroke while taxiing for takeoff.NTSB FTW02LA088Accident · No injuriesLimited investigationFinal reportFokker F-28 MK-100 · Dallas, TXThe ground crew inadvertent application of deicing fluid in the auxiliary power unit resulting in an overspeed and turbine wheel burst. A contributing factor was the gusty wind.NTSB ANC02LA021Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Whittier, AKThe pilot's Failure to maintain a proper descent rate during landing. Factors associated with the accident are variable wind conditions, and the pilot's improper approach to the landing site.NTSB ANC02FA020Accident · No injuriesField investigationFinal reportCessna 208B · Barrow, AKThe pilot's continued flight into adverse weather conditions, and an inadvertent stall. Factors associated with the accident are fog, obscuration, and icing conditions.NTSB NYC02LA067Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Grove City, OHThe pilot's inadequate compensation for wind conditions which resulted in an in-flight collision with trees. A factor related to the accident was the gusting wind conditions.NTSB ATL02LA060Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Schlater, MSan unknown person at an unknown time exceeded the engine temperature limitations that resulted in the failure of compressor turbine and the subsequent loss of engine power during takeoff.NTSB SEA02LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Longmont, COThe pilot's failure to maintain directional control of the aircraft during landing. Factors were a contaminated runway, which was icy and covered with snow, and a snow bank.NTSB FTW02LA089Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Tulsa, OKthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.