Skip to content

NTSB investigations: Cessna 150M, 1976

72 cases on aircraft the registry lists as Cessna 150M. 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

19642026

NTSB investigations: Cessna 150M, 1976 per year, 1964–2026: 1,283 cases
1964	1
1965	1
1968	1
1969	1
1970	1
1974	6
1975	43
1976	72
1977	123
1978	104
1979	84
1980	57
1981	48
1982	53
1983	40
1984	40
1985	27
1986	31
1987	38
1988	32
1989	39
1990	34
1991	27
1992	26
1993	30
1994	32
1995	27
1996	26
1997	16
1998	22
1999	31
2000	17
2001	10
2002	7
2003	9
2004	9
2005	12
2006	9
2007	12
2008	9
2009	2
2010	6
2011	5
2012	7
2013	1
2014	4
2015	11
2016	3
2017	3
2018	6
2019	5
2020	4
2021	3
2022	1
2023	3
2024	6
2025	4
2026	2

Where

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") = 1976 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071830')) 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\") = 1976
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071830'))
  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") = 1976
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071830'))
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 MKC77DCQ11Accident · Minor injuriesClosedCessna 150 · Emporia, KSDec 25, 1976 · N6306K · Substantial damage NTSB FTW77DPG13Accident · No injuriesClosedCessna 150 · Mt.Home, ARDec 24, 1976 · N66094 · Substantial damage NTSB CHI77FEE08Accident · No injuriesClosedCessna 150 · Wayne, ILDec 18, 1976 · N63406 · Substantial damage NTSB CHI77DEE06Accident · No injuriesClosedCessna 150M · Belvidere, ILDec 4, 1976 · N9172U · Substantial damage NTSB CHI77FEI05Accident · No injuriesClosedCessna 150 · Vienna, OHDec 3, 1976 · N8632U · Substantial damage NTSB CHI77DEV05Accident · No injuriesClosedCessna 150 · Decatur, ILNov 24, 1976 · N8778U · Substantial damage NTSB NYC77DNC10Accident · Minor injuriesClosedCessna 150 · Hampton, NHNov 13, 1976 · N45160 · Substantial damage NTSB FTW77FRA04Accident · Serious injuriesClosedCessna 150M · Chester, TXNov 10, 1976 · N10EB · Destroyed NTSB IAD77FLJ05Accident · Minor injuriesClosedCessna 150 · Woodland, NCNov 5, 1976 · N63283 · Substantial damage NTSB NYC77FNC06Accident · Minor injuriesClosedCessna 150M · Cherryfield, MENov 2, 1976 · N760CA · Substantial damage NTSB LAX77FUG04Accident · No injuriesClosedCessna 150 · Ettiwanda, CAOct 29, 1976 · N45394 · Substantial damage NTSB IAD77DKM06Accident · No injuriesClosedCessna 150 · Banner Elk, NCOct 29, 1976 · N88656 · Substantial damage NTSB MIA77FKJ03Accident · Serious injuriesClosedCessna 150 · New Brockton, ALOct 25, 1976 · N802AA · Substantial damage NTSB NYC77FHD03Accident · No injuriesClosedCessna 150M · Waterford, NJOct 22, 1976 · N7986U · Substantial damage NTSB CHI76FA003Accident · 1 fatalClosedCessna 150M · Amherst, WIOct 20, 1976 · N704PN · Destroyed NTSB DEN77FA002Accident · 2 fatalClosedCessna 150 · Texico, NMOct 19, 1976 · N66113 · Destroyed NTSB MKC77FCG03Accident · Minor injuriesClosedCessna 120 · Waldron, MOOct 17, 1976 · N1980V · 2 aircraft · Destroyed NTSB NYC77FHD01Accident · No injuriesClosedCessna 150 · West Chester, PAOct 16, 1976 · N63150 · Substantial damage NTSB IAD77DIG03Accident · No injuriesClosedCessna 150 · Easton, MDOct 16, 1976 · N7574U · Substantial damage NTSB SEA77DYC01Accident · No injuriesClosedCessna 150 · Lebanon, OROct 10, 1976 · N150FW · Substantial damage NTSB DEN77FTM03Accident · No injuriesClosedCessna 150 · Salt Lake City, UTSep 30, 1976 · N45230 · Substantial damage NTSB MIA76DKT99Accident · No injuriesClosedCessna 150 · Opalocka, FLSep 27, 1976 · N66374 · Substantial damage NTSB FTW76AF121Accident · 1 fatalClosedCessna 150M · Kiefer, OKSep 13, 1976 · N45690 · Destroyed NTSB ANC76AA129Accident · 1 fatalClosedCessna 150 · Sterling, AKSep 11, 1976 · N63215 · Substantial damage NTSB CHI76AC090Accident · 2 fatalClosedCessna 150M · Salem, ILSep 7, 1976 · N6244K · Destroyed NTSB MIA76DKH08Accident · No injuriesClosedCessna 150 · Columbus, GASep 6, 1976 · N45256 · Substantial damage NTSB LAX76DVQ51Accident · No injuriesClosedCessna 150 · Lancaster, CASep 5, 1976 · N66046 · Substantial damage NTSB LAX76FUQ49Accident · Minor injuriesClosedCessna 150 · Lancaster, CAAug 25, 1976 · N6135K · Destroyed NTSB CHI76FEE74Accident · 1 fatalClosedCessna 150M · Lockport, ILAug 24, 1976 · N7TZ · Substantial damage NTSB OAK76FVH05Accident · No injuriesClosedCessna 150 · Elk Grove, CAAug 21, 1976 · N9289U · Substantial damage NTSB NYC76FFJ28Accident · No injuriesClosedCessna 150M · Brockport, NYAug 2, 1976 · N8440U · Substantial damage NTSB ANC76AA117Accident · 1 fatalClosedCessna 150 · Nome, AKAug 1, 1976 · N7672U · Destroyed NTSB CHI76FEI38Accident · No injuriesClosedCessna 150 · Cleveland, OHJul 28, 1976 · N9451U · Substantial damage NTSB IAD76DKM42Accident · Minor injuriesClosedCessna 150 · Bessemer City, NCJul 25, 1976 · N9194U · Substantial damage NTSB FTW76DRJ34Accident · No injuriesClosedCessna 150M · Oil City, LAJul 24, 1976 · N66127 · Substantial damage NTSB MKC76DCA37Accident · No injuriesClosedCessna 150 · Cuba, MOJul 22, 1976 · N63199 · Substantial damage NTSB MIA76DLD71Accident · No injuriesClosedCessna 150 · Arcadia, FLJul 21, 1976 · N8360U · Destroyed NTSB CHI76FC079|CHI76AC079Accident · 5 fatalClosedCessna 150M · Rockford, ILJul 17, 1976 · N66375 · 2 aircraft · Destroyed NTSB IAD76AI081Accident · 3 fatalClosedCessna 150 · Elkhorn City, KYJul 4, 1976 · N9238U · Substantial damage NTSB FTW76FRA50Accident · Minor injuriesClosedCessna 150 · Huffman, TXJul 4, 1976 · N3801V · Substantial damage NTSB MKC76DTG19Accident · Minor injuriesClosedCessna 150M · Rolette, NDJun 28, 1976 · N3749V · Substantial damage NTSB SEA76DYC59Accident · Serious injuriesClosedCessna 150M · Brightwood, ORJun 27, 1976 · N45611 · Destroyed NTSB NYC76AN106Accident · 1 fatalClosedCessna 150M · Lockport, NYJun 27, 1976 · N7901U · Destroyed NTSB CHI76AC067Accident · 1 fatalClosedCessna 150M · Peoria, ILJun 9, 1976 · N66101 · Destroyed NTSB NYC76DHA35Accident · No injuriesClosedCessna 150 · Tunkhannock, PAJun 5, 1976 · N3092V · Substantial damage NTSB CHI76FEV42Accident · No injuriesClosedCessna 150M · Springfield, ILJun 5, 1976 · N8993U · Substantial damage NTSB FTW76FRJ26Accident · No injuriesClosedCessna 150M · Texarkana, ARMay 19, 1976 · N45547 · Substantial damage NTSB FTW76DRA40Accident · No injuriesClosedCessna 150 · Deweyville, TXMay 19, 1976 · N45459 · Substantial damage NTSB CHI76FEV39Accident · No injuriesClosedCessna 150M · Springfield, ILMay 19, 1976 · N66380 · Substantial damage NTSB FTW76DQG77Accident · No injuriesClosedCessna 150 · Levelland, TXMay 18, 1976 · N7926U · Substantial damage