NTSB investigations · 18

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 ERA26FA179Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 401B · Land O' Lakes, FLOn April 19, 2026, about 0834 eastern daylight time, a Cessna 401B, N122AT, was destroyed when it was involved in an accident near Land O’ Lakes, Florida. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Apr 19, 2026 · N122AT · Destroyed NTSB CEN21WA093Accident · No injuriesClass 4 · ForeignCessna 401B · Toussus-le-Noble, FranceOct 30, 2020 · N517HC · Substantial damage 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 MIA91WA054Accident · Serious injuriesForeign investigationCessna 401B · Marsh Harbor, BahamasDec 26, 1990 · N799NW · Destroyed 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

Back to Cessna 401B