NTSB investigations
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 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 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 WPR26LA321Accident · No injuriesClass 3 · LimitedPreliminary reportWestwind 1124A · Las Vegas, NVOn August 28, 2026, about 0145 Pacific daylight time, an IAI 1124A Westwind airplane, Canadian registration C-GIAW, was substantially damaged when it was involved in an accident at Harry Reid International Airport (LAS), Las Vegas, Nevada. The two pilots, and…NTSB CEN26LA303Accident · No injuriesClass 4 · LimitedInvestigation openAmerican Champion 8GCBC · Westminster, CONTSB WPR26LA342Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180E · Salem, ORNTSB GAA26WA312Accident · 2 fatalClass 5 · ForeignTecnam P2006T · Kampur, IndiaNTSB ERA26LA320Accident · No injuriesClass 3 · LimitedPreliminary reportHawker Beechcraft 400A · Newark, NJOn August 27, 2026, about 1625 eastern daylight time, a Hawker Beechcraft Corporation 400A airplane, N199TT, was substantially damaged when it was involved in an accident near Newark, New Jersey. The airline transport pilot and commercial pilot were not…NTSB ERA26LA316Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-18A 150 · New Smyrna Beach, FLOn August 27, 2026, about 1051 eastern daylight time, a Piper PA-18A 150, N2368P, was substantially damaged when it was involved in an accident near New Smyrna Beach, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA26LA340Accident · Serious injuriesClass 4 · LimitedInvestigation openAirbus A319-132 · Houston, TXNTSB ANC26LA092Accident · Minor injuriesClass 4 · LimitedInvestigation openAutogyro Cavalon · Conroe, TXNTSB WPR26LA318Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170B · South Lake Tahoe, CANTSB GAA26WA307Accident · No injuriesClass 5 · ForeignBeech C90 · Belo Horizonte, BrazilNTSB GAA26WA303Accident · No injuriesClass 5 · ForeignBeech G58 · Parana, BrazilNTSB ANC26FA091Accident · 4 fatalClass 3 · FieldPreliminary reportPiper PA-24-260 · Seldovia, AKOn August 26, 2026 about 1317 Alaska daylight time, a Piper PA-24-260 airplane, N9485P, was substantially damaged when it was involved in an accident near Seldovia, Alaska. The pilot and three passengers were fatally injured. The airplane was operated as a…NTSB WPR26LA317Accident · No injuriesClass 4 · LimitedInvestigation openBoeing A75N1(PT17) · Cedar Rapids, IANTSB GAA26WA296Accident · No injuriesClass 5 · ForeignCessna 152 · Ratmalana, Sri LankaNTSB GAA26WA295Accident · 1 fatalClass 5 · ForeignBeech 58 · Groote Eylandt, AustraliaNTSB ERA26LA315Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Rural Retreat, VAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA26LA313Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Milton, FLThe flight instructor’s failure to maintain control of the helicopter during a low hover over a grass area, which resulted in left skid contact with the ground and a dynamic rollover to the left.NTSB DCA26WA343IncidentForeign investigationAirbus A320 · Mascot, AustraliaNTSB CEN26LA301Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 172M · Frankston, TXNTSB ANC26LA090Accident · No injuriesClass 4 · LimitedInvestigation openRepublic RC-3 · Evansville, INNTSB WPR26LA319Accident · No injuriesClass 4 · LimitedInvestigation openRotorsport UK Rotorsport UK Cavalo · Brenham, TXNTSB WPR26LA314Accident · No injuriesClass 4 · LimitedInvestigation openKfa Safari · Coolin, IDNTSB WPR26LA313Accident · No injuriesClass 4 · LimitedInvestigation openStinson 108-1 · Joseph, ORNTSB DCA26WA338Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Hongseong, South KoreaNTSB CEN26LA302Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-22-150 · Brenham, TXNTSB CEN26LA299Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150M · Greenwood, ILNTSB WPR26LA316Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Bemidji, MNNTSB WPR26LA311Accident · No injuriesClass 4 · LimitedInvestigation openCessna T210M · Logan, UTNTSB WPR26LA310Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172P · Gulfport, MSNTSB ERA26LA322Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-32R-300 · Thomaston, GANTSB ERA26LA314Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 421 · Fulton, KYThe misfuelling of the airplane by the refueler. Contributing to the accident was the pilot’s failure to verify that the airplane had been properly fueled prior to departing on the accident flight.NTSB ERA26LA312Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA24 · Fort Washington, MDNTSB ERA26LA311Accident · No injuriesClass 4 · LimitedFinal reportHPH Glasflugel 304CZ · Xenia, OHThe glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.NTSB CEN26LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206H · Marble, COThe pilot's failure to maintain directional control during the final approach in variable and gusting wind conditions. Contributing to the accident were localized wind effects associated with mountainous terrain and with nearby convective activity.NTSB WPR26LA312Accident · Serious injuriesClass 3 · LimitedPreliminary reportSchweizer G-164B · Olene, OROn August 20, 2026, about 9:32 Pacific daylight time, a Schweizer Aircraft Corp., G-164B, N7501Q, was destroyed when it was involved in an accident near Orlene, Oregon. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26FA309Accident · 8 fatalClass 3 · FieldPreliminary reportCessna 441 · Cape Newenham, AKOn August 20, 2026, at about 1145 Alaska daylight time, a Cessna 441, N128EZ, was destroyed when it was involved in an accident near Cape Newenham, Alaska. The two pilots and six passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA292Accident · 1 fatalClass 5 · ForeignBeech 200 · Prince George, CanadaNTSB GAA26WA288Accident · No injuriesForeign investigationCessna P206 · Playa Muerto, PanamaNTSB ERA26FA310Accident · 1 fatalClass 3 · FieldPreliminary reportDiamond Aircraft Ind DA20-A1 · Bristol, MEOn August 20, 2026, about 1300 eastern daylight time, a Diamond Aircraft Ind Inc DA20-A1, N83RF, was substantially damaged when it was involved in an accident near Bristol, Maine. The pilot was fatally injured, and the pilot-rated passenger sustained minor…NTSB DCA26WA325Occurrence · No injuriesForeign investigationBoeing 737 · Chisinau, MoldovaNTSB CEN26LA296Accident · 1 fatalClass 3 · LimitedPreliminary reportPara-Ski VX · Westport, SDOn August 19, 2026, about 1920 central daylight time, a Para-Ski VX powered parachute, C-IFBY, was substantially damaged when it was involved in an accident near Westport, South Dakota. The pilot sustained serious injuries, passenger 1 sustained fatal…NTSB GAA26WA286Incident · No injuriesClass 5 · ForeignGuimbal Cabri · Oxford, United KingdomNTSB GAA26WA285Accident · 7 fatalClass 5 · ForeignEurocopter EC130 · Ewaso Nyiro, KenyaNTSB ERA26FA309Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 150 · Carlisle, PAOn August 19, 2026, at 1852 eastern daylight time, a Bell Helicopter Textron Canada 407, N873ST, and a Cessna 150H airplane, N23330, collided in flight near Carlisle, Pennsylvania. The two commercial pilots onboard the helicopter were seriously injured, and…NTSB ANC26LA089Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna 180J · Bettles, AKNTSB ENG26WA039OccurrenceClass 5 · ForeignBoeing 737 · Cancun, MexicoNTSB ANC26LA088Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172L · Micanopy, FLOn August 18, 2026 at 1100 eastern daylight time, a Cessna 172L, N3866Q, was substantially damaged when it was involved in an accident near Micanopy, Florida. The flight instructor and student pilot were uninjured. The airplane was operated as a Title 14 Code…NTSB WPR26LA325Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150 · Socorro, NMNTSB GAA26WA283Accident · 3 fatalClass 5 · ForeignBell 206 · Exambela, GreeceNTSB CEN26LA297Accident · Minor injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Searcy, ARThe flight instructor’s failure to maintain airplane control during landing in gusting wind conditions.