NTSB investigations, 2002
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\") = 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 DEN03LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350BA · Monticello, UTthe pilot's failure to maintain rotor rpm. A related factor was the presence of an object in the path during the touchdown.NTSB SEA03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Pasco, WAIcing conditions and the pilot's failure to maintain adequate airspeed during the landing. An inadvertent stall was a factor.NTSB MIA03LA021Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Brevard, NCthe jamming of the elevator control system for undetermined reason, which resulted in the airplane departing the runway, and impacting with a ditch, during the aborted takeoff.NTSB LAX03TA043Accident · No injuriesFinal reportBell 47G-3B-1 · Panaca, NVseparation of the no. 6 cylinder intake valve head from the valve stem, which resulted in a loss of engine power. The mechanism responsible for the valve failure is unknown.NTSB CHI03LA032Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jeffersonville, INThe mechanical binding of the left main landing gear, which resulted in the left main landing gear not fully extending to the down-and-locked position. Factors to the accident were the oleo-strut linkage being corroded and the contamination of the gear…NTSB ANC03LA017Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chenega Bay, AKThe pilot's selection of unsuitable terrain for landing and his failure to maintain obstacle clearance which resulted in the airplane colliding with a tree and a berm.NTSB ANC03LA016Accident · No injuriesLimited investigationFinal reportPiper J5A · Soldotna, AKThe pilot's failure to remove all water from the airplane's fuel supply during the preflight inspection, which resulted in a loss of engine power and subsequent hard landing.NTSB SEA03FA015Accident · 2 fatalField investigationFinal reportCaron Seawind · Bryant, WAA loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain.NTSB DEN03LA019Accident · Serious injuriesLimited investigationFinal reportCameron Balloons O-70 · Montrose, COthe unforecasted increase in wind velocity. A contributing factor was the fence that the basket struck, subsequently spilling the occupants onto the ground.NTSB SEA03TA014Accident · No injuriesFinal reportHughes OH-6A · Snohomish, WALoss of engine power for undetermined reasons while in cruise flight. A tree was a factor.NTSB MIA03LA022Accident · No injuriesLimited investigationFinal reportLet L-23 · Groveland, FLthe pilot's failure to extend the dive brakes during approach and his excessive airspeed and improper landing flare which resulted in the airplane nosing down and impacting with the runway.NTSB FTW03FA053Accident · 1 fatalField investigationFinal reportCessna 172N · Lindsay, OKThe in-flight separation of the right wing due to the missing nut that secures the right wing's strut to fuselage fitting to the fuselage.NTSB CHI03LA031Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-211 · Minneapolis, MNThe cabin flight crew not verifying the galley service cart had been properly stowed prior to departure, which resulted in the inadvertent deployment of the galley service cart during initial climb after takeoff.NTSB MIA03LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Powells Point, NCa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB LAX03LA042Accident · No injuriesLimited investigationFinal reportCessna 170B · Mobile, AZthe pilot's improper compensation for the crosswind conditions at touchdown and failure to maintain proper alignment of the tail wheel equipped airplane during landing, which resulted in a ground loop. The crosswind was a contributory factor.NTSB LAX03LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Hollister, CAthe pilot's failure to maintain directional control of the airplane.NTSB FTW03LA052Accident · No injuriesLimited investigationFinal reportShepherd Kolb Mark III · Norfork, ARThe loss of engine power due to fuel contamination. Contributing to the accident were the trees.NTSB CHI03LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cuba, MOThe pilots inadequate flare and recovery from a bounced landing. Contributing factors to this accident were the crosswind and the ditch.NTSB NYC03LA026Accident · No injuriesLimited investigationFinal reportCessna TR182 · Willoughby, OHThe pilot's failure to select the alternator to the "ON" position before initiating the flight. A factor in the accident was the tailwind which resulted in the overrun.NTSB LAX03LA041Accident · Serious injuriesLimited investigationFinal reportClyde K Carrier Team 1400Z · Woodland, CAthe builder/pilot's improper modification of wing fuel caps resulting in the failure of the vent system to adequately compensate for the pressure differential between the fuel tank and the external low pressure area of the wing. This led to the partial loss…NTSB LAX03LA040Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Elko, NVThe pilot's inadequate in-flight planning/decision resulting in fuel exhaustion.NTSB IAD03WA020Incident · No injuriesForeign investigationBritish Concorde · Atlantic Ocean (Atlantic Ocean)NTSB IAD03FA019Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Bastian, VAThe pilot's failure to maintain an adequate altitude above terrain. Factors in the accident were the dark night conditions and the low cloud ceiling.NTSB FTW03FA051Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · McAlester, OKThe pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around which resulted in his loss of control. Contributing factors to the accident included the loss of power from the left engine as a result of…NTSB DEN03LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Vernal, UTthe pilot's improper in-flight planning/decision. Factors contributing to the accident were fuel exhaustion and the fog.NTSB SEA03FA013Accident · 2 fatalField investigationFinal reportCessna 172P · Malaga, WAThe pilot's attempted VFR flight into IMC resulting in the aircraft colliding with trees and up sloping terrain. Contributing factors were clouds, trees, and uphill terrain. The pilot’s performance and judgment were likely impaired by the effects of…NTSB DEN03LA022Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Creede, COthe pilot's inadequate compensation for wind. Contributing factors are the crosswind and the pilot's lack of experience.NTSB LAX03FA037Accident · 1 fatalField investigationFinal reportBeech B36TC · Union City, CAthe pilot's failure to maintain an adequate terrain clearance altitude, which resulted in controlled flight into rising mountainous terrain. Contributing factors were the pilot's loss of situational awareness to his terrain proximity, the dark night, and the…NTSB FTW03LA049Accident · 2 fatalLimited investigationFinal reportGirard RV-4 · Homer, LAThe pilot's VFR flight into IMC conditions and his failure to obtain/maintain altitude/clearance from trees during the initial climb after takeoff. Contributing factors were fog and trees.NTSB FTW03FA048Accident · 2 fatalField investigationFinal reportBeech A36 · Salem, UTThe pilot's inadequate inflight planning/decision to continue flight from visual to instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain while in cruise flight. A low ceiling, obscuration, mountainous terrain…NTSB ATL03LA021Accident · No injuriesLimited investigationFinal reportCessna T210M · Lakeland, FLThe collapse of the main landing gear for undetermined reasons.NTSB LAX03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Santa Paula, CAThe pilot's failure to follow the checklist and switch the fuel selector to the fullest tank for landing, which resulted in fuel starvation and loss of engine power.NTSB ENG03RA003Incident · No injuriesForeign investigationBoeing 717 · Hobart,Tasmania, AustraliaNTSB ATL03LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain airspeed during an approach to land that resulted in an inflight collision with the runway. A factor was the crosswind condition.NTSB SEA03LA017Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Rigby, IDThe pilot's selection of a fuel tank with inadequate fuel resulting in fuel starvation and a complete power loss during the initial climb. A contributing factor was the ditch which the aircraft impacted during the forced landing resulting in the collapse of…NTSB SEA03LA011Accident · Serious injuriesLimited investigationFinal reportPeterson Dragonfly · Mulino, ORFuel starvation of the engine while in cruise flight due to the owner/builder's alteration of the fuel system from that shown in the aircrafts plans. Factors include very rough terrain in the area where the pilot found it necessary to make his forced landing.NTSB NYC03LA025Accident · No injuriesLimited investigationFinal reportCessna 172G · Stow, MAThe pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.NTSB NYC03LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Prestonsburg, KYThe loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.NTSB DEN03LA018Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Morrison, COthe pilot not maintaining clearance from the telephone lines during landing. Factors contributing to the accident were the pilot not being able to see the telephone lines, the low altitude, and the dark night.NTSB CHI03LA029Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Stalwart, MIThe pilot's improper fuel management during the flight and the pilot's improper decision not to select the outboard fuel tank when a loss of engine power was experienced, resulting in fuel starvation, a sustained loss of engine power, and subsequent forced…NTSB CHI03LA028Accident · No injuriesLimited investigationFinal reportWoods Velocity · Claflin, KSThe total loss of engine power while in cruise flight due to vapor lock of the fuel line as a result of the fractured exhaust manifold. A factor was the unsuitable terrain encountered during the forced landing.NTSB CHI03LA024Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Coffeyville, KSThe pilot not maintaining aircraft control during the maneuver to avoid an unconfirmed object on the side of the runway.NTSB ATL03LA018Accident · No injuriesLimited investigationFinal reportHickman Murphy Rebel · Hilton Head, SCThe pilot's failure to maintain directional control during an aborted landing that resulted in the in-flight collision with a ditch.NTSB SEA03LA012Accident · No injuriesLimited investigationFinal reportBell 212 · Longview, WAThe pilot's failure to maintain clearance from trees while landing. A contributing factor was trees.NTSB FTW03LA047Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M18A · Votaw, TXA loss of engine power for undertermined reasons. Contributing factors included the unsuitable terrain for the forced landing and the lack of airspeed.NTSB WAS03WA002Accident · Minor injuriesForeign investigationBell 214B1 · Hanla Mountain, South KoreaNTSB LAX03LA036Accident · No injuriesLimited investigationFinal reportAsmus Exec 162F · Monterey, CAThe loss of engine power for undetermined reasons. A factor in the accident was the pilot's failure to maintain aircraft control during the forced landing.NTSB FTW03LA058Accident · No injuriesLimited investigationFinal reportRamsay Lancair IV-P · Bulverde, TXThe pilot's misjudgment of speed and distance.NTSB CHI03IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-131 · Chicago, ILThe maintenance facililty improperly assembled and installed the nose landing gear shock absorber assembly. Factors were the improper assembly which allowed the nose gear to turn 90 degrees to the direction of travel.NTSB NYC03FA024Accident · 1 fatalField investigationFinal reportSocata TB-20 · Massena, NYThe pilot's failure to maintain airspeed, which resulted in a stall. Factors in this accident were the icing conditions, deteriorated airplane performance due to ice accumulation, and control interference by the passenger as reported by the pilot.