NTSB investigations: Cessna 411, FL

12 cases on aircraft the registry lists as Cessna 411. 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

19772026

NTSB investigations: Cessna 411, FL per year, 1977–2026: 12 cases
1977	2
1978	1
1979	1
1980	2
1981	1
1983	1
1986	1
1988	1
1991	1
1997	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."eventStateOrRegion" = 'FL' 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 ('2075902')) 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.\"eventStateOrRegion\" = 'FL' 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 ('2075902'))
  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" = 'FL' 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 ('2075902'))
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 MIA97LA253Accident · No injuriesLimited investigationFinal reportCessna 411 · Williston, FLthe pilot-in-command's excessive taxi speed.Sep 13, 1997 · N12WT · Substantial damage NTSB MIA91FA172Accident · Serious injuriesField investigationFinal reportCessna 411 · North Ft. Myers, FLThe pilot in commands failure to follow emergency procedures and his failure to maintain airspeed following loss of power in one engine resulting in an inadvertent stall and the inflight loss of control with subsequent inflight collision with an object and…Jun 28, 1991 · N4940T · Destroyed NTSB MIA88FA094Accident · 1 fatalField investigationFinal reportCessna 411 · Venice, FLWitnesses stated that the acft was climbing & just after takeoff, the left wing dropped, the acft then leveled off, climbed aprx 75 more feet. The acft then abruptly turned hard left & went straight in, striking a wall surrounding a swimming pool, burst into…Jan 27, 1988 · N235UV · Destroyed NTSB MIA86LA176Accident · No injuriesLimited investigationFinal reportCessna 411 · Tallahassee, FLThe plt observed a fuel spill on the ground as a result of refueling overflow. He attempted to start the engines & an explosion & fire resulted.Jun 11, 1986 · N4959T · Substantial damage NTSB MIA83FA226Accident · Serious injuriesField investigationFinal reportCessna C-114A · Ft. Lauderdale, FLThe acft crashed while maneuvering at low airspeed and altitude right after takeoff. The plt said the left engine started losing power intermittently at 90 KTS. The plt had rotated the acft and tried to continue the takeoff. He was cleared to land on any rwy…Sep 10, 1983 · N256EL · Destroyed NTSB MIA82DKJ02Accident · No injuriesClosedCessna 411 · Panama City, FLDec 30, 1981 · N222WW · Substantial damage NTSB MIA80FA091Accident · 2 fatalClosedCessna 411A · Cape Coral, FLAug 18, 1980 · N1411M · Destroyed NTSB MIA80FA082Accident · Serious injuriesClosedCessna 411 · Pompano Beach, FLJul 7, 1980 · N3CC · Destroyed NTSB MIA79FA036Accident · 3 fatalClosedCessna 411 · Jacksonville, FLJan 8, 1979 · N7338U · Destroyed NTSB MIA78FLD37Accident · No injuriesClosedCessna 411 · Kissimmee, FLApr 24, 1978 · N411HG · Substantial damage NTSB MIA77PLD83Accident · No injuriesClosedCessna 411 · New Prt Richey, FLSep 5, 1977 · N4920T · Substantial damage NTSB MIA77FA026Accident · 2 fatalClosedCessna 411 · Ft Myers, FLJan 25, 1977 · N99JM · Destroyed