NTSB investigations
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 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 WPR26LA093Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 500 · Great Falls, MTOn January 19, 2026, about 1303 mountain standard time, a Cessna 500 airplane, C-GJVK, was substantially damaged when it was involved in an accident at Great Falls International Airport (GTF), Great Falls, Montana. The pilot and passenger were not injured.…NTSB WPR26LA087Accident · Serious injuriesClass 4 · LimitedFinal reportKitfox Series 7 · Lemmon Valley-Golden Valley, NVThe pilot’s inability to maintain clearance from terrain during a go-around.NTSB WPR26LA083Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Parkman, WYThe pilots’ failure to maintain separation while conducting air work in a common operational area. Contributing to the accident was the pilots’ divided attention associated with the mission activity and unreliable radio communications.NTSB GAA26WA078Incident · No injuriesClass 5 · ForeignPiper PA23 · Santiago, ChileNTSB ERA26LA099Accident · No injuriesClass 4 · LimitedFinal reportFrankewich Walter S-21 Outbound · Madisonville, TNThe pilot’s failure to compensate for gusty crosswind conditions during the landing roll, which resulted in a loss of control and subsequent runway excursion.NTSB WPR26LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Lewiston, IDThe pilot’s improper landing flare, which resulted in hard, bounced landing and subsequent tail strike.NTSB WPR26FA082Accident · Serious injuriesClass 3 · FieldPreliminary reportBell Helicopter Textron 206L-1 · Kamas, UTOn January 18, 2026, about 1510 mountain standard time, a Bell 206L-1, N138DD, was substantially damaged when it was involved in an accident near Kamas, Utah. The pilot and three passengers received minor injuries. The helicopter was operated as a Title 14…NTSB GAA26WA098IncidentClass 5 · ForeignBell 212 · Mt Hotham Aerodrome, AustraliaNTSB GAA26WA080Accident · Minor injuriesClass 5 · ForeignAir Tractor AT401 · Planalto da Serra, BrazilNTSB CEN26FA093Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-140 · Holly Springs, MSOn January 18, 2026, about 1640 central standard time, a Piper PA28-140 airplane, N6711J, was destroyed when it was involved in an accident near Holly Springs, Mississippi. The flight instructor and student pilot were fatally injured. The airplane was…NTSB WPR26LA090Accident · No injuriesClass 3 · LimitedPreliminary reportLake LA-4-200 · Dewey, WAOn January 16, 2026, at 1609 Pacific daylight time, a Lake LA-4-200, N48X sustained substantial damage when it was involved in an accident near Dewey, Washington. The flight instructor and student pilot were uninjured. The amphibious airplane was operated as…NTSB WPR26LA084Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Cody, WYThe pilot's failure to maintain directional control during landing roll.NTSB GAA26WA077Accident · Serious injuriesClass 5 · ForeignCessna T-206H · Saltillo, Coahuila, MexicoNTSB GAA26WA074Accident · 3 fatalClass 5 · ForeignRobinson R44 · Rio de Janeiro, BrazilNTSB DCA26WA108Accident · 10 fatalClass 5 · ForeignATR ATR42 · Makassar, IndonesiaNTSB DCA26LA097Accident · No injuriesClass 4 · LimitedInvestigation openBoeing 767 · San Bernardino, CANTSB CEN26LA096Accident · No injuriesClass 3 · LimitedPreliminary reportHonda HA-420 · Amarillo, TXOn January 16, 2026, at 1154 central standard time, a Honda HA-420 airplane, N949LL, was substantially damaged when it was involved in an accident near Amarillo, Texas. The airline transport pilot and four passengers were uninjured. The airplane was operated…NTSB CEN26LA094Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172K · Amery, WIOn January 16, 2026, about 1130 central standard time, a Cessna 172 airplane, N79118, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC26LA010Accident · No injuriesClass 4 · LimitedFinal reportBeech 65-A90-1 · Anchorage, AKThe pilot’s failure to attain proper flare during landing resulting in a hard landing short of the runway threshold. Contributing to the accident were gusting wind conditions.NTSB WPR26LA086Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206L-3 · Logsden, ORThe inadvertent entanglement of a long line with the skid, which resulted in a loss of flight control. Contributing to the accident was the use of nylon lines instead of steel cables to secure the bucket.NTSB ERA26LA096Accident · No injuriesClass 4 · LimitedFinal reportAmerican General Acft AG5B · Fairfield, NJThe pilot’s failure to maintain an appropriate glide path during the landing approach in gusting wind conditions, resulting in an impact with trees prior to the runway.NTSB DCA26WA160Accident · No injuriesClass 5 · ForeignATR ATR42 · Simberi, Papua New GuineaNTSB DCA26LA102Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · Kodiak, AKThe reduced surface friction of the contaminated ramp which led to a loss of directional control during taxi.NTSB CEN26LA091Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Burnet, TXThe pilot’s improper judgement to relinquish his pilot responsibilities to the passenger with the engine operating, which resulted in a loss of airplane control and impact with a parked vehicle.NTSB WPR26LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 172E · Kingman, AZThe pilot’s failure to use a pre-takeoff checklist, which resulted in the fuel selector being in the off position, and subsequent loss of engine power during takeoff.NTSB WPR26LA080Accident · No injuriesClass 3 · LimitedPreliminary reportFairchild SA227-AC · Prescott, AZOn January 13, 2026, about 0624 mountain standard time, a Fairchild SA227-AC airplane, N370AE, was substantially damaged when it was involved in an accident near Prescott Municipal Airport (PRC), Prescott, Arizona. The pilot was not injured. The airplane was…NTSB GAA26WA079Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Barreiras, BrazilNTSB ERA26LA129Accident · No injuriesClass 3 · LimitedPreliminary reportRaytheon G58 · Savannah, GAOn January 13, 2026, about 1100 eastern standard time, a Raytheon Aircraft Company G58 airplane, N58GL sustained substantial damage when it was involved in an accident near Savannah, Georgia. The pilot was not injured. The airplane was operated as a Title 14…NTSB ERA26LA093Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 177 · Ocoee, TNOn January 13, 2026, about 1530 eastern standard time, a Cessna 177B, N34959, was substantially damaged when it was involved in an accident near Ocoee, Tennessee. The pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA090Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 750 · Mountain Village, COOn January 13, 2026 about 1220 mountain standard time, a Cessna 750, N772XJ, was substantially damaged when it was involved in an accident near Mountain Village, Colorado. The pilots and passenger were not injured. The airplane was operated under the…NTSB ANC26LA009Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-31-310 · Anchorage, AKNTSB GAA26WA137Accident · Serious injuriesClass 5 · ForeignAyres S2R600 · Lebu, ChileNTSB ERA26LA091Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Port St. Lucie, FLOn January 10, 2026, about 1925 eastern standard time, a Piper PA-28-180, N6516J was substantially damaged when it was involved in an accident near Port St. Lucie, Florida. The pilot and passenger sustained serious injuries. The airplane was operated as a…NTSB DCA26WA092Incident · No injuriesClass 5 · ForeignSaab SF340 · Auckland, New ZealandNTSB CEN26LA088Accident · No injuriesClass 4 · LimitedInvestigation openAeronca 7AC · Early, TXNTSB CEN26LA087Accident · Minor injuriesClass 3 · LimitedPreliminary reportStinson 108-3 · Gypsum, COOn January 11, 2026, at 1408 mountain standard time, a Stinson 108-3 airplane, N6725M, sustained substantial damage when it was involved in an accident near Gypsum, Colorado. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB WPR26LA079Accident · No injuriesClass 4 · LimitedFinal reportKubicek Factory S R O BB26M · La Verkin, UTThe pilot’s failure to maintain clearance from powerlines after an aborted landing attempt.NTSB GAA26WA072Accident · 6 fatalClass 3 · ForeignPiper PA-31-325 · Paipa, ColombiaNTSB GAA26WA070Accident · Serious injuriesClass 5 · ForeignCessna 208 · Kansar, IndiaNTSB GAA26WA073Accident · 1 fatalClass 3 · ForeignAir Tractor AT602 · Lucas do Rio Verde, BrazilNTSB ERA26LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Flemington, GAThe pilot’s inadvertent manipulation of the mixture control, which resulted in a total loss of engine power during initial climb and a subsequent forced lading.NTSB DCA26WA094IncidentClass 5 · ForeignBoeing 737 · Shymkent, KazakhstanNTSB ERA26LA094Accident · Minor injuriesClass 4 · LimitedFinal reportSled Thomas Helicycle · Mobile, ALThe pilot’s failure to maintain yaw control during a crosswind approach, which resulted in a loss of tail rotor effectiveness, an uncommanded spin, hard landing, and subsequent rollover.NTSB ERA26LA088Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Philippi, WVThe pilot’s failure to obtain the proper touchdown point, which resulted in a runway overrun.NTSB CEN26LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Bay City, MIThe pilot's failure to ensure the landing gear was down and locked before landing.NTSB CEN26FA086Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Sabine Pass, TXOn January 8, 2026, about 1431 central standard time, a Beech A36 airplane, N5677X, was substantially damaged when it was involved in an accident near Sabine Pass, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title…NTSB WPR26LA078Accident · No injuriesClass 3 · LimitedPreliminary reportBeech K35 · Prescott, AZOn January 7, 2026, at about 0809 mountain standard time, a Beech K35, N6010E, was substantially damaged when it was involved in an accident near Prescott, Arizona. The pilot and flight instructor were not injured. The airplane was operated as a Title 14 Code…NTSB GAA26WA071Accident · No injuriesClass 5 · ForeignCessna 208 · Nuwara Eliya, Sri LankaNTSB GAA26WA067Accident · 2 fatalClass 5 · ForeignRobinson R44 · Bardymsky Municipal District, RussiaNTSB ERA26LA090Accident · No injuriesClass 4 · LimitedFinal reportDevesh Tiwary Lightning XS · New Port Richey, FLThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.