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 ANC03LA013Accident · No injuriesLimited investigationFinal reportCessna 180 · Larson Bay, AKThe pilot's failure to maintain adequate clearance while landing, which resulted in an in-flight collision with a tree.NTSB ANC03LA012Accident · No injuriesLimited investigationFinal reportCurtiss-Wright CW-46 · Fairbanks, AKThe failure of the right main landing gear locking device to engage, which allowed the right main landing gear to collapse during taxi from landing.NTSB ANC03LA007Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Marshall, AKThe pilot's failure to maintain clearance from terrain, which resulted in an in-flight collision with a ridgeline. Factors contributing to the accident were the high terrain, the pilot's inadequate preflight planning, and the dark night light conditions.NTSB ANC03CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Palmer, AKThe premature liftoff by the pilot during takeoff, which resulted in on ground encounter with terrain when the airplane settled onto rocks. A contributing factor in the accident was an unfavorable wind.NTSB FTW03WA021Accident · 4 fatalForeign investigationPiper PA-34-200T · Caraballeda, VenezuelaNTSB MIA03FA007Accident · 2 fatalField investigationFinal reportCessna 172M · Coral Springs, FLThe failure of the dual students and flight instructors on both N9840V and N6101F to see and avoid each other, which resulted in a midair collision.NTSB IAD03LA010Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Springfield, OHInadequate installation of the number 3 cylinder.NTSB CHI03LA016Accident · No injuriesLimited investigationFinal reportLaFerriere Vans RV-4 · Lake Geneva, WIThe loss of engine power due to carburetor ice. A contributing factor was the ditch adjacent to the roadway.NTSB CHI03LA012Accident · No injuriesLimited investigationFinal reportMork Kitfox III · Evansville, WIThe loss of power for undetermined reasons. A contributing factor is the unsuitable terrain.NTSB MIA03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Vero Beach, FLThe collapse of the nose landing gear for undetermined reasons resulting in the loss of directional control and the subsequent collapse of the main landing gears.NTSB MIA03LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Sebring, FLThe student pilot's premature rotation and failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall, an uncontrolled descent, and an impact with the ground.NTSB FTW03LA019Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Plainview, TXThe pilot's failure to maintain clearance with the wires. Contributing factors were the low ceilings and the prevailing haze.NTSB DCA03MA008Accident · 8 fatalClass 1 · MajorFinal reportBeech King Air 100 · Eveleth, MNThe flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.NTSB CHI03FA014Accident · Minor injuriesField investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe driver of the bus not maintaining clearance from the taxiing airplane.NTSB ATL03FA010Accident · 3 fatalField investigationFinal reportCessna R182 · Greensboro, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. Factors were low ceilings and fog.NTSB ANC03CA006Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain proper alignment on the taxiway and clearance from the taxiway edge lights while taxiing from landing. A factor contributing to the accident was sun glare.NTSB NYC03LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Morristown, NJThe student pilot's failure to maintain directional control during takeoff.NTSB NYC03LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakewood, NJThe pilot's improper use of carburetor heat which resulted in a failure to remove carburetor ice, and loss of engine power. A factor was the carburetor icing conditions.NTSB ATL03FA009Accident · 2 fatalField investigationFinal reportBeechcraft A60 · Jesup, GAThe loss of power in one engine and the loss of control for undetermined reasons.NTSB ATL03FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Spanish Fort, ALthe pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.NTSB NYC03LA013Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Cottageville, WVThe pilot's improper decision not to over fly the landing area, which resulted in an in-flight collision with power lines.NTSB MIA03LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Las Palmas, PRThe pilot's failure to switch fuel tanks resulting in a partial loss of engine power due to fuel starvation during a go-around. Additionally, the pilot's failure to monitor airspeed and proper touchdown point during the emergency landing resulted in another…NTSB MIA03FA005Accident · 1 fatalField investigationFinal reportCessna 310 · Merritt Island, FLThe pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.NTSB IAD03LA009Accident · No injuriesLimited investigationFinal reportCessna 185 · Waterville, METhe pilot's excessive braking during the landing roll, which resulted in a nose over. A factor was the quartering tailwind.NTSB IAD03LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Middlesboro, KYThe pilot's operation of the airplane with a known deficiency. Factors related to the accident were the loss of engine power of the left engine due to a failure of the left engine-driven and electric fuel pumps, and inadequate maintenance.NTSB IAD03IA017Incident · No injuriesIncident investigationFinal reportCraig N. Moen RV-8 · Leesburg, VAA low-stress, high-cycle fatigue fracture of the right ignition timing rotor.NTSB FTW03LA023Accident · No injuriesLimited investigationFinal reportBeech A23 · Farmington, ARThe loss of engine power due to the failure of the mechanical fuel pump.NTSB DEN03LA011Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Fort Collins, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airspeed resulting in a stall.NTSB ANC03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Bethel, AKThe failure of both pilot's to maintain a visual outlook during taxi operations on the ramp.NTSB MIA03WA011Incident · No injuriesForeign investigationBoeing 767-300 · Buenos Aires, ArgentinaNTSB LAX03LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Queen Creek, AZa loss of engine power for undetermined reasons.NTSB LAX03LA014Accident · Serious injuriesLimited investigationFinal reportCessna 210C · Riverside, CAthe pilot's failure to position the fuel selector to the tank containing fuel resulting in a loss of engine power due to fuel exhaustion.NTSB CHI03LA010Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Kincaid, ILThe pilot not maintaining altitude/clearance from the terrain during the aerobatic maneuver. A factor to the accident was the pilot being impaired by alcohol.NTSB ATL03IA006Incident · No injuriesIncident investigationFinal reportAmerican Blimp A-60 · Valdosta, GALoss of airship control during tie down, due to gusty wind conditions.NTSB ANC03CA004Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in the left wing striking the runway.NTSB NYC03LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, MAThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel contamination. Factors in this accident were the corroded fuel tanks caps, and an inadequate annual inspection.NTSB LAX03FA013Accident · 3 fatalField investigationFinal reportPiper Aerostar 601 · Agua Dulce, CAthe pilot's failure to attain and maintain a sufficient airspeed, which led to an inadvertent stall mush. The pilot's selection of the wrong runway for departure, considering the uphill gradient, the wind direction, and a takeoff path into rising terrain are…NTSB FTW03FA016Accident · 6 fatalField investigationFinal reportPiper PA-32-301 · Paron, ARThe pilot's failure to maintain altitude/clearance from terrain. Contributing factors were the low ceiling, the pilot's decision to fly in known adverse weather conditions, and his lack of an instrument rating.NTSB DEN03LA008Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-C1 · Grand Junction, COThe pilot's inadequate preflight and in-flight planning resulting in fuel mismanagement and fuel exhaustion.NTSB DCA03IA005Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Baltimore, MDThe captain's improper procedures regarding stall avoidance and recovery. Contributing to the incident were the partial blockage of the pitot static system, and the flight crew's improper decisions regarding their use of inaccurate airspeed indications.…NTSB CHI03LA011Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, MIThe pilot not maintaining directional control during landing and the inoperative right main landing gear brake. Contributing factors were the failed brake master cylinder seal, resulting in a hydraulic leak, the inadequate preflight by the pilot, the fuel…NTSB LAX03LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Van Nuys, CAfuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB LAX03LA011Accident · No injuriesLimited investigationFinal reportRotorway 162F · Tucson, AZthe failure of the secondary drive shaft.NTSB IAD03IA007Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Boston, MAAn inadvertant collision with birds during the initial climb out.NTSB FTW03WA020Accident · 2 fatalForeign investigationBell 430 · Jalapa, MexicoNTSB FTW03LA018Accident · No injuriesLimited investigationFinal reportCarriere RW-152 Scorpion II · Opelousas, LAThe pilot's inadequate compensation for wind resulting in a loss of control. A contributing factor was the gusting wind conditions.NTSB DEN03LA010Accident · No injuriesLimited investigationFinal reportHildebrandt Rutan/Defiant · Watkins, COthe pilot's failure to use the checklist, resulting in his forgetting to lower the nose landing gear. Contributing factors included the pilot's attention being diverted by the loss of oil pressure on the rear engine due to a broken oil pressure sensor line,…NTSB ATL03LA007Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Highfalls, GAThe pilots inadequate fuel management, and subsequent loss of engine power due to fuel exhaustion, and a in-flight collision with trees during an autorotation. A factor was the pilot's failure to insure that the required equipment (fuel gauge) was installed…NTSB NYC03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Hartwood, VAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion.NTSB NYC03IA011Incident · No injuriesIncident investigationFinal reportPiper PA-28-236 · Altoona, PAA failure of the fuel selector for an undetermined reason.