NTSB investigations: Cessna 411, 1971

10 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

19662026

NTSB investigations: Cessna 411, 1971 per year, 1966–2026: 96 cases
1966	1
1967	6
1968	9
1969	1
1970	2
1971	10
1972	5
1973	7
1974	4
1975	6
1976	3
1977	6
1978	4
1979	3
1980	3
1981	3
1982	2
1983	2
1984	1
1985	1
1986	2
1987	1
1988	2
1990	1
1991	1
1992	1
1996	1
1997	1
1999	1
2000	1
2002	1
2003	2
2004	1
2005	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 year(c."eventDate") = 1971 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 year(c.\"eventDate\") = 1971
    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 year(c."eventDate") = 1971
  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 DEN72FQA30Accident · Minor injuriesClosedCessna 411 · Alameda, NMDec 29, 1971 · N4977T · Substantial damage NTSB DEN72AD030Accident · 5 fatalClosedCessna 411 · Stockton, UTDec 26, 1971 · N411Q · Destroyed NTSB DEN72FQA15Accident · No injuriesClosedCessna 411 · Albuquerque, NMAug 30, 1971 · N3236R · Substantial damage NTSB IAD71FKM40Accident · No injuriesClosedCessna 411A · Greensboro, NCJun 23, 1971 · N7363U · Substantial damage NTSB OAK71FVW35Accident · No injuriesClosedCessna 411 · Las Vegas, NVJun 10, 1971 · N999RS · Substantial damage NTSB CHI71FEE76Accident · No injuriesClosedCessna 411 · Northbrook, ILJun 7, 1971 · N256EL · Substantial damage NTSB FTW71FQD17Accident · No injuriesClosedCessna 411 · El Paso, TXApr 19, 1971 · N4949T · Substantial damage NTSB NYC71FFG15Accident · Minor injuriesClosedCessna 310N · Auburn, MEJan 19, 1971 · N5046Q · Substantial damage NTSB NYC71AN082Accident · 1 fatalClosedCessna 411 · Little Ferry, NJJan 19, 1971 · N7386U · Destroyed NTSB CHI71FDJ36Accident · No injuriesClosedCessna 411 · Milwaukee, WIJan 13, 1971 · N610GC · Substantial damage