NTSB investigations: Cessna 140, 1977
32 cases on aircraft the registry lists as Cessna 140. 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
| 1964 | 108 |
|---|---|
| 1965 | 106 |
| 1966 | 80 |
| 1967 | 95 |
| 1968 | 74 |
| 1969 | 66 |
| 1970 | 50 |
| 1971 | 44 |
| 1972 | 55 |
| 1973 | 40 |
| 1974 | 46 |
| 1975 | 31 |
| 1976 | 23 |
| 1977 | 32 |
| 1978 | 24 |
| 1979 | 18 |
| 1980 | 14 |
| 1981 | 21 |
| 1982 | 15 |
| 1983 | 23 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 16 |
| 1987 | 12 |
| 1988 | 8 |
| 1989 | 11 |
| 1990 | 11 |
| 1991 | 16 |
| 1992 | 13 |
| 1993 | 11 |
| 1994 | 18 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 12 |
| 1999 | 11 |
| 2000 | 11 |
| 2001 | 8 |
| 2002 | 3 |
| 2003 | 9 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 7 |
| 2008 | 7 |
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 7 |
| 2012 | 1 |
| 2013 | 8 |
| 2014 | 5 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 9 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 9 |
| 2022 | 9 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 8 |
| 2026 | 5 |
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 year(c.\"eventDate\") = 1977
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071602', '2071603'))
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") = 1977
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071602', '2071603'))
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 NYC78DNC07Accident · No injuriesClosedCessna 140 · Jaffey, NHNTSB CHI78FEC05Accident · No injuriesClosedCessna 140 · W.Bloomfield, MINTSB LAX78FUJ06Accident · No injuriesClosedCessna 140 · Tonopah, AZNTSB MIA78FKG03Accident · Serious injuriesClosedCessna 140 · Calhoun, GANTSB MKC78FCD06Accident · No injuriesClosedCessna 140 · Ankeny, IANTSB MIA78DKG02Accident · No injuriesClosedCessna 140 · Tifton, GANTSB CHI77BEX52Accident · No injuriesClosedCessna 140 · Anderson, INNTSB MIA77DKG80Accident · No injuriesClosedCessna 140 · Blairsville, GANTSB DEN77DTC29Accident · Minor injuriesClosedCessna 140 · Cody, WYNTSB ANC77DAH34Accident · Serious injuriesClosedCessna 140 · Kenai, AKNTSB DEN77DTE72Accident · No injuriesClosedCessna 140 · Platner, CONTSB MKC77DCJ39Accident · No injuriesClosedCessna 140 · Kimball, NENTSB SEA77DYM50Accident · No injuriesClosedCessna 140 · Rufus, ORNTSB MIA77FKG20Accident · Minor injuriesClosedCessna 140 · Whitesburg, GANTSB MIA77FLG23Accident · Serious injuriesClosedCessna 140 · Isle Of Palms, SCNTSB MKC77DER54Accident · Minor injuriesClosedCessna 140 · Monticello, MNNTSB IAD77DID22Accident · No injuriesClosedCessna 140 · Leedsville, VANTSB SEA77FTA24Accident · No injuriesClosedCessna 140 · Jordan, MTNTSB SEA77FTI14Accident · Minor injuriesClosedCessna 140 · Stevensville, MTNTSB NYC77FHJ20Accident · No injuriesClosedCessna 140 · Farmingdale, NYNTSB NYC77FFA23Accident · No injuriesClosedCessna 140 · Potsdam, NYNTSB MIA77FLT03Accident · Minor injuriesClosedCessna 140 · Walls, MSNTSB FTW77DPG29Accident · No injuriesClosedCessna 140 · Marion, ARNTSB SEA77FYM29Accident · Minor injuriesClosedCessna 140 · Vancouver, WANTSB NYC77DFA19Accident · No injuriesClosedCessna 140 · Monticello, NYNTSB MKC77DCQ28Accident · No injuriesClosedCessna 140 · Kirwin, KSNTSB LAX77FVA07Accident · Minor injuriesClosedCessna 140 · Long Beach, CANTSB MKC77DTK09Accident · No injuriesClosedCessna 140 · Philip, SDNTSB CHI77FEX14Accident · No injuriesClosedCessna 140 · Crawfordsville, INNTSB SEA77FTA12Accident · No injuriesClosedCessna 140 · Hinsdale, MTNTSB LAX77FUG28Accident · No injuriesClosedCessna 140 · Redlands, CANTSB LAX77FA023Accident · 1 fatalClosedCessna 140 · Riverside, CA