Final NTSB investigations: Cessna 401B

15 cases on aircraft the registry lists as Cessna 401B. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19702026

Final NTSB investigations: Cessna 401B per year, 1970–2026: 15 cases
1970	1
1976	1
1977	1
1979	2
1980	3
1981	2
1984	1
1992	1
1999	1
2004	1
2017	1

Where

Open the map

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590E')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590E'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590E'))
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 ERA18FA004Accident · 2 fatalField investigationFinal reportCessna 401 · Salters, SCThe pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane, and his subsequent failure to maintain control of the airplane during the maneuver. Contributing to the accident was the pilot's impairment by the effects of…Oct 4, 2017 · N401HH · Destroyed NTSB ATL04LA148Accident · No injuriesLimited investigationFinal reportCessna 401B · Naples, FLThe fracture of the right landing gear down lock stud which resulted in the right main landing gear collapse during landing roll.Jul 10, 2004 · N7983Q · Substantial damage NTSB NYC00FA001Accident · Serious injuriesField investigationFinal reportCessna 401B · Caldwell, NJThe pilot's inadequate preflight, which resulted in an attempted takeoff with the pitot covers installed. An additional cause was the pilot's delayed decision to abort the takeoff, while factors included the misleading airspeed indications, and the proximity…Oct 2, 1999 · N88VA · Destroyed NTSB CHI93LA040Accident · No injuriesLimited investigationFinal reportCessna 401B · Rice Lake, WIImproper rigging of the right main landing gear retract bellcrank by other maintenance personnel.Nov 27, 1992 · N7989Q · Substantial damage NTSB ANC84LAMS1Accident · 5 fatalFinal reportCessna 401 · Anchorage, AKAt 0630 AKDT the plt obtained a wx briefing for the flt which forecast VFR with occasional marginal conditions along the route of flt. At 0704, the plt obtained an updated briefing at which time the destination of cantwell was reported IFR. At 0731 AKDT, the…Jul 25, 1984 · N7984Q · No damage NTSB MIA81FLD65Accident · No injuriesClosedCessna 401B · Tampa, FLSep 17, 1981 · N7969Q · Substantial damage NTSB MKC81FCQ12Accident · No injuriesClosedCessna 401B · Goodland, KSFeb 9, 1981 · N7986Q · Substantial damage NTSB NYC80FA069Accident · 2 fatalClosedCessna 401B · Tewksbury, MAAug 12, 1980 · N2ST · Destroyed NTSB MIA80FLA24Accident · Serious injuriesClosedCessna 401 · Gainsville, FLMay 12, 1980 · N7931Q · Substantial damage NTSB IAD80FA037Accident · 1 fatalClosedCessna 401 · Linville, NCApr 7, 1980 · N9912F · Destroyed NTSB LAX79FUJ89Accident · No injuriesClosedCessna 401B · Scottsdale, AZJun 22, 1979 · N7902Q · Substantial damage NTSB LAX79FUJ80Accident · Minor injuriesClosedCessna 401B · Phoenix, AZJun 5, 1979 · N77MG · Destroyed NTSB CHI77FEI11Accident · No injuriesClosedCessna 401B · Vienna, OHFeb 4, 1977 · N7923Q · Substantial damage NTSB IAD77FID03Accident · Minor injuriesClosedCessna 401 · Hot Springs, VAOct 24, 1976 · N2WP · Destroyed NTSB SEA71AS004Accident · 1 fatalClosedCessna 401B · Yakima, WAJul 21, 1970 · N7917Q · Destroyed