NTSB investigations, 2002
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 LAX03WA221Accident · 3 fatalForeign investigationPiper PA-31-325 · Fielding, New ZealandNTSB MIA03CA030Accident · No injuriesData collectionFinal reportCessna A150M · Crystal River, FLThe student pilot's improper application of brakes during the landing rollout, which resulted in a loss of directional control and the airplane running off of the runway, impacting a runway light structure, and nosing over.NTSB LAX03LA050Accident · No injuriesLimited investigationFinal reportAnderson Rotorway Exec 162F · Phoenix, AZThe separation of the exhaust valve stem in the number 1 cylinder, which resulted in a partial loss of engine power during the landing flare and a hard landing.NTSB LAX03FA051Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Anaheim Hills, CAthe pilot's encounter with forecast severe turbulence during an inadvertent penetration of an intense weather cell, which resulted in the pilot exceeding the design structural limits of the airplane. A factor in the accident was the pilot's inadequate…NTSB MIA03WA042Accident · 2 fatalForeign investigationCessna 206 · El Carmen, ColombiaNTSB MIA03LA028Accident · No injuriesLimited investigationFinal reportBeech A36 · Laurens, SCImproper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation…NTSB LAX03FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-34-200T · Pacific Ocean (Pacific Ocean)undetermined, missing aircraft.NTSB CHI03LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Jackson, MIThe pilot's failure to follow the checklist and extend the landing gear resulting in a gear up landing.NTSB MIA03LA033Accident · No injuriesLimited investigationFinal reportBeech 200 · Jacksonville, FLFailure of the main landing gear locking mechanism for undetermined reasons, which resulted in the main landing gear collapsing, and damage to the airplane during landing.NTSB MIA03LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Cashiers, NCThe pilot's inadequate in-flight decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain terrain clearance. Contributing factors were a low ceiling and mountainous terrain.NTSB FTW03LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bryson, TXthe pilot's inadequate inflight planning and decision which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane and dark night conditions were contributing factors.NTSB NYC03IA030Incident · No injuriesIncident investigationFinal reportPiper PA-601P · Manassas, VAThe pilot' failure to maintain directional control during an aborted takeoff.NTSB MIA03WA031Accident · 2 fatalForeign investigationPiper PA-23-250 · Freeport, BahamasNTSB LAX03LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fallon, NVThe pilot's failure to maintain control of the airplane during a low altitude maneuver. Contributing factors were the inadequate passenger briefing regarding the flight controls and the passenger's inadvertent use of the rudder.NTSB FTW03LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Odessa, TXThe pilot's inadvertent failure to extended the landing gear.NTSB CHI03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Greensburg, INFailure of the pilot to maintain directional control during the takeoff roll. Contributing factors included inadequate planning/decision by the pilot for attempting to depart from the slush covered runway, the slush covered runway itself, and the falling snow.NTSB ANC03LA022Accident · 1 fatalLimited investigationFinal reportCessna 180 · Petersburg, AKAn in flight collision with ocean water for an undetermined reason.NTSB NYC03LA029Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Suffolk, VAThe pilot's inadequate visual lookout while landing, which resulted in a collision with an embankment.NTSB IAD03WA023Accident · Minor injuriesForeign investigationCessna 206H · Lawa Antino, SurinameNTSB CHI03LA037Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Frankenmuth, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB DEN03LA024Accident · No injuriesLimited investigationFinal reportMooney M20K · Eagle, COthe pilot's failure to remove protective coverings from the engine air scoops during the preflight inspection, resulting in air starvation and a loss of engine power shortly after takeoff. A contributing factor was the lack of suitable terrain for a forced…NTSB CHI03LA036Accident · 2 fatalLimited investigationFinal reportNorth American T-28B · Glenwood, MNThe altitude/clearance not maintained by the pilot-in-command. The low altitude maneuvering by the pilot-in-command was a contributing factor.NTSB LAX03TA048Accident · No injuriesFinal reportCessna T210L · Agua Caliente, CAThe failure of the right main landing gear actuator during the landing roll, which resulted in a collapse of the right main land gear, and loss of directional control.NTSB LAX03LA047Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Scottsdale, AZThe pilot's inadequate preflight inspection and failure to refuel the airplane resulting in a loss of engine power due to fuel starvation.NTSB FTW03FA059Accident · 3 fatalField investigationFinal reportBeech 1900C · Eagleton, ARIn-flight collision with terrain due to the pilot's failure to maintain clearance and altitude above rapidly rising terrain while on a VFR approach. Contributing factors were the obscuration of the terrain due to clouds.NTSB MIA03CA026Accident · No injuriesData collectionFinal reportPiper PA38 · Pensacola, FLThe student pilot's attempt to turn off the runway at an excessive taxi speed resulting in a loss of directional control and collision with a taxiway sign.NTSB ENG03WA004Incident · No injuriesForeign investigationBoeing 767-219ER · Brisbane, AustraliaNTSB MIA03WA027Accident · 4 fatalForeign investigationCessna U206G · Pucallpa, PeruNTSB MIA03FA025Accident · 2 fatalField investigationFinal reportRaytheon 58 · Fort Myers, FLthe pilot's spatial disorientation during instrument meteorological conditions, which resulted in his failure to maintain aircraft control. Contributing factors included the pilot's distraction to the low fuel status and the low cloud conditions.NTSB MIA03FA024Accident · 2 fatalField investigationFinal reportAaa Aircraft Leasing 192 · Miami, FLThe inflight fire of undetermined origin, which resulted in pilot incapacitation, loss of aircraft control and an inflight collision with a building.NTSB DEN03FA023Accident · 1 fatalField investigationFinal reportRockwell Commander 114 · Hot Springs, ARthe loss of engine power due to the failure of the engine ignition system's single-drive dual-magneto, and the magneto's improper installation by unknown maintenance personnel. Contributing factors were the improper installation of the magneto by unknown…NTSB CHI03LA040Accident · No injuriesLimited investigationFinal reportCessna 172M · Moline, ILThe pilot's failure to maintain altitude clearance during a base to final turn on approach. Contributing factors to the accident were the night conditions and the trees.NTSB ATL03LA024Accident · No injuriesLimited investigationFinal reportCessna 172N · Cartersville, GAThe student pilot's failure to maintain directional control, during the landing roll resulted in the on ground collision with a ravine.NTSB ATL03FA023Accident · 2 fatalField investigationFinal reportCessna 150L · Arecibo, PRThe pilots failure to follow the normal takeoff checklist (Wing Flaps-Up) and failure to maintain airspeed after takeoff that resulted in an inadvertent stall.NTSB CHI03IA033Incident · No injuriesIncident investigationFinal reportHughes OH-6 · Moberly, MOThe loss of tail rotor effectiveness during cruise flight due to the bellcrank pivot pin becoming separated from the non-rotational swashplate. The plain brass liner of the non-rotating swashplate and the bellcrank pivot pin were worn.NTSB SEA03LA016Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Tekoa, WAThe pilot's failure to maintain clearance from the terrain while attempting to fly a non-IFR equipped aircraft solely by reference to its instruments after the aircraft's windshield became coated with freezing rain in cruise flight. A factor was the pilot's…NTSB NYC03LA028Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Dalton, MAThe pilot's inadequate preflight inspection of the aircraft, which resulted in a total loss of engine power due to fuel contamination. A factor was the cold air temperature.NTSB LAX03FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Phelan, CAthe student pilot's failure to maintain an adequate airspeed while maneuvering that lead to a stall spin and impact with flat desert terrain.NTSB IAD03LA022Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Leeds, MAThe flight instructor's failure to ensure adequate fuel onboard, which resulted in fuel exhaustion and a total loss of engine power.NTSB IAD03LA021Accident · No injuriesLimited investigationFinal reportCessna 210M · Cincinnati, OHRupture of the left side, landing gear down hydraulic line due to repeated contact with the aileron cable, which resulted in a loss of hydraulic pressure, a partial extension of the main landing gear, and the inability to utilize the landing gear hand pump.NTSB FTW03FA057Accident · 1 fatalField investigationFinal reportCessna 210L · Harrison, ARThe pilot's failure to maintain control of the aircraft and the exceedance of the manufactured limits, which resulted in an in flight break-up. Contributing factors were the dark night conditions and the clouds.NTSB FTW03FA055Accident · 1 fatalField investigationFinal reportCessna 421C · Tajique, NMThe pilot's failure to maintain terrain clearance. Factors contributing to the accident were the high mountains, mountain obscuration, the dark night condition, and the pilot's improper in-flight planning/decision making.NTSB FTW03FA054Accident · 1 fatalField investigationFinal reportCessna 402C · Lewisville, TXThe failure of the attitude indicator, and the pilot's failure to maintain aircraft control as a result of spatial disorientation following the failure of the attitude indicator. Contributing factors were a low ceiling, clouds, and dark night conditions.NTSB CHI03LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Holland, MIThe student pilot failed to maintain directional control during landing roll. Additional factors include the student pilot's lack of total flight experience, the CFI's inadequate supervision, and the ice and snow on the runway.NTSB SEA03LA010Accident · No injuriesLimited investigationFinal reportLearjet 36A · Astoria, ORCollision with an elk during the takeoff roll. Factors include dark night VFR conditions.NTSB MIA03LA023Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Gainesville, GAa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB LAX03LA044Accident · No injuriesLimited investigationFinal reportCessna 150H · Twentynine Palm, CAThe improper use of carburetor heat, and the instructor's inadequate supervision which resulted in a loss of engine power due to carburetor icing.NTSB FTW03LA056Accident · No injuriesLimited investigationFinal reportCessna 172M · Vici, OKThe pilot's departure and continued flight into adverse weather conditions. Contributing factors were the icing conditions, and the lack of suitable terrain for the precautionary landing.NTSB ATL03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Eastman, GAThe pilots failure to maintain a visual lookout resulting in the subsequent on ground collision with a hangar.NTSB MIA03CA063Accident · No injuriesData collectionFinal reportConsolidated Aeronautics LA-4-200 · Blountstown, FLThe failure of the certified flight instructor (CFI) to maintain clearance between the wingtip and a water marker bouy resulting in contact with the wingtip.