NTSB investigations: Cessna 401A, NC
5 cases on aircraft the registry lists as Cessna 401A. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1970 | 2 |
|---|---|
| 1973 | 1 |
| 1983 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
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 c.\"eventStateOrRegion\" = 'NC' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590D'))
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."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590D'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA26LA050Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 401 · Eureka, NCOn November 18, 2025, at 12:30 eastern standard time, a Cessna 401A, N6255Q, was substantially damaged when it was involved in an accident near Eureka, North Carolina. The commercial pilot received minor injuries. The airplane was operated as a Title 14 Code…NTSB ATL83LA373Accident · No injuriesLimited investigationFinal reportCessna 401A · Monroe, NCThe left landing gear collapsed on the acft as it was being taxied into the ramp. After turning left into the hub area the landing gear horn sounded and the left gear collapsed, according to the plt. A flt instructor who witnessed the accident said the ACFT'3…NTSB IAD73FLJ21Accident · No injuriesClosedCessna 401A · Morrisville, NCNTSB IAD71DKM23Accident · No injuriesClosedCessna 401A · Winston Salem, NCNTSB NYC70AN108Accident · 5 fatalClosedCessna 401A · Morrisville, NC