Skip to content

NTSB investigations

23 cases where the defining event was Off-field or emergency landing.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20182026

Where

Latest cases

Query with SQL

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 c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '440') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '440')
  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 c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '440')
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 ERA26LA127Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-151 · Arno, TNOn February 24, 2026, about 1107 central standard time, a Piper PA-28-151, N85RW, was substantially damaged when it was involved in an accident near Arno, Tennessee. The pilot was not injured. The airplane was operated as a 14 Code of Federal Regulations Part…Feb 24, 2026 · N85RW · Substantial damage NTSB WPR25LA292Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182N · Fallbrook, CAOn September 23, 2025, about 1400 Pacific daylight time, N766EE, a Cessna 182N, was substantially damaged when it was involved in an accident near Fallbrook, California. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…Sep 23, 2025 · N766EE · Substantial damage NTSB ERA25LA350Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Astatula, FLOn September 17, 2025 at 1000 eastern daylight time, a Piper PA-28-181 100i, N580JA, was substantially damaged when it was involved in an accident near Astatula, Florida. The student pilot sustained minor injuries. The airplane was operated as a 14 Code of…Sep 17, 2025 · N580JA · Substantial damage NTSB WPR25LA265Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 120 · Taylor, AZOn August 24, 2025, about 0711 mountain daylight time, a Cessna 120, N3151N, was substantially damaged when it was involved in an accident near Taylor, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…Aug 24, 2025 · N3151N · Substantial damage NTSB WPR25LA163Accident · No injuriesClass 3 · LimitedPreliminary reportRans S20 · Fairfield, UTOn May 27, 2025, about 1330 mountain daylight time, an experimental amateur-built RANS S20 Raven, N327KM, was substantially damaged when it was involved in an accident near Fairfield, Utah. The pilot was not injured. The airplane was operated as a Title 14…May 27, 2025 · N327KM · Substantial damage NTSB GAA25WA162Accident · Minor injuriesClass 5 · ForeignCessna 150 · Ucharpi, IndiaMar 31, 2025 · VT-PBA NTSB GAA24WA053AccidentClass 5 · ForeignAir Tractor AT301 · Orihueca, ColombiaDec 9, 2023 · HK4952 · Substantial damage NTSB GAA24WA001Accident · No injuriesClass 3 · ForeignRobinson R44 · Vamdrup, DenmarkOct 4, 2023 · OY-HFS · Substantial damage NTSB GAA23WA251Accident · No injuriesClass 5 · ForeignRobinson R44 · Manta, EcuadorSep 8, 2023 · HC-CPV · Substantial damage NTSB GAA23WA176Accident · Minor injuriesClass 5 · ForeignCessna 182 · Jelenia Góra, PolandJun 25, 2023 · D-EDYP · Substantial damage NTSB GAA23WA166Accident · No injuriesClass 5 · ForeignBeech A36 · Teresina, Pi, BrazilJun 11, 2023 · PT-DLO · Substantial damage NTSB GAA23WA160Accident · No injuriesClass 5 · ForeignPiper PA-34-220T · São Pedro da Água Branca,, BrazilMay 29, 2023 · PT-WMF · Substantial damage NTSB GAA23WA102Accident · Serious injuriesClass 5 · ForeignQuicksilver GT500 · Flaminio Suárez, ColombiaFeb 26, 2023 · HJ-320 · Substantial damage NTSB ERA22LA326Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Waynesville, OHThe pilot’s loss of situational awareness (geographic position), which resulted in his inability to locate the intended landing runway and his decision to perform an off-airport landing.Jul 10, 2022 · N3616Q · Substantial damage NTSB CEN22LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Rogers, ARThe pilot’s failure to establish a stabilize approach criteria during low-level maneuvering to the runway, which resulted in a hard landing and contact with a hay bale.Jul 9, 2022 · N83552 · Substantial damage NTSB GAA22WA215Accident · Minor injuriesClass 4 · ForeignRobinson R44 · Rio das Ostras, BrazilJun 20, 2022 · PP-MDS · Substantial damage NTSB GAA21WA057AccidentClass 5 · ForeignPartenavia P68 · Bhopal, IndiaMar 27, 2021 · VT-TAA · Substantial damage NTSB GAA21WA056Accident · 2 fatalClass 5 · ForeignCessna 208 · Ndetani, KenyaMar 20, 2021 · 5Y-JKN · Destroyed NTSB GAA21WA070Accident · Serious injuriesClass 3 · ForeignBell 212 · Región del Libertador Bernardo O´Higgins, ChileJan 27, 2021 · CC-ATY · Substantial damage NTSB CEN21LA102Accident · 1 fatalClass 3 · LimitedFinal reportHughes 369D · Tuckers Crossing, MSThe pilot’s loss of helicopter control when the external saw contacted trees during an attempted emergency landing due to a main rotor transmission oil pressure warning. The reason that the pilot did not release the external saw from the helicopter during the…Dec 29, 2020 · N103SU · Destroyed NTSB CEN20CA236Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 1730A · Martinton, ILThe pilot's improper decision to conduct an off-field precautionary landing.Jun 19, 2020 · N244HW · Substantial damage NTSB WPR20LA121Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Angostura, NMThe pilots precautionary off airport landing due to an undetermined engine issue.Apr 10, 2020 · N2112A · Substantial damage NTSB WPR18LA133Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Borrego Springs, CAThe loss of the helicopter’s drive system for reasons that could not be determined from the available evidence, which led to an autorotation that resulted in a hard landing and rollover on uneven sandy terrain.Apr 30, 2018 · N423ML · Substantial damage