Skip to content

NTSB investigations: Cessna 150L, 1976

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

19702026

NTSB investigations: Cessna 150L, 1976 per year, 1970–2026: 1,492 cases
1970	2
1971	35
1972	56
1973	116
1974	153
1975	123
1976	104
1977	95
1978	83
1979	54
1980	59
1981	27
1982	34
1983	28
1984	17
1985	26
1986	27
1987	27
1988	19
1989	28
1990	35
1991	29
1992	29
1993	18
1994	21
1995	18
1996	18
1997	11
1998	21
1999	10
2000	14
2001	16
2002	7
2003	8
2004	7
2005	9
2006	9
2007	10
2008	6
2009	9
2010	6
2011	8
2012	3
2013	5
2014	2
2015	4
2016	6
2017	2
2018	4
2019	2
2020	5
2021	6
2022	4
2023	5
2024	8
2026	4

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 ('2071826')) 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 ('2071826'))
  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 ('2071826'))
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 OAK77FVA13Accident · Minor injuriesClosedCessna 150L · Madera, CADec 31, 1976 · N5419Q · Destroyed NTSB MKC77DCJ07Accident · No injuriesClosedCessna 150 · Omaha, NEDec 29, 1976 · N16210 · Substantial damage NTSB MIA77DLD20Accident · No injuriesClosedCessna 150 · Vero Beach, FLDec 24, 1976 · N18594 · Substantial damage NTSB IAD77DLQ04Accident · Minor injuriesClosedCessna 150 · Trenton, KYDec 22, 1976 · N11269 · Destroyed NTSB MIA77DKT10Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLDec 11, 1976 · N19075 · Substantial damage NTSB DEN77FTE09Accident · No injuriesClosedCessna 150 · Boulder, CODec 11, 1976 · N11961 · Substantial damage NTSB LAX77FUJ11Accident · Minor injuriesClosedCessna 150 · Mesa, AZDec 8, 1976 · N5433Q · Substantial damage NTSB LAX77FUG14Accident · Serious injuriesClosedCessna 150 · Etiwanda, CADec 7, 1976 · N66012 · Substantial damage NTSB NYC77DFA08Accident · No injuriesClosedCessna 150 · Kingston, NYDec 5, 1976 · N6738G · Substantial damage NTSB MIA76FA008Accident · 1 fatalClosedCessna 150L · Orlando, FLNov 16, 1976 · N7511G · Destroyed NTSB SEA77FYA06Accident · Minor injuriesClosedCessna 150L · Mountain Home, IDNov 14, 1976 · N6788G · Substantial damage NTSB LAX77DUM07Accident · No injuriesClosedCessna 150 · Rancho Snta Fe, CANov 6, 1976 · N6768G · Substantial damage NTSB FTW77FA011Accident · 1 fatalClosedCessna 150 · Denton, TXNov 6, 1976 · N1336Q · 2 aircraft · Destroyed NTSB ANC76DAH09Accident · No injuriesClosedCessna 150 · Summit, AKNov 6, 1976 · N19366 · Substantial damage NTSB CHI77FEV03Accident · No injuriesClosedCessna 150L · Marion, ILOct 27, 1976 · N1611Q · Substantial damage NTSB CHI77FEM08Accident · No injuriesClosedCessna 150L · Sparta, MIOct 25, 1976 · N17236 · Destroyed NTSB ANC77DAA02Accident · No injuriesClosedCessna 150 · Galena, AKOct 14, 1976 · N19251 · Substantial damage NTSB LAX77FVA07Accident · 1 fatalClosedCessna 150 · Kernville, CAOct 10, 1976 · N1402Q · Substantial damage NTSB MIA77FLD03Accident · No injuriesClosedCessna 150L · Merritt Island, FLOct 3, 1976 · N6868G · Substantial damage NTSB CHI77FEM06Accident · No injuriesClosedCessna 150 · Lansing, MIOct 3, 1976 · N10747 · Substantial damage NTSB CHI76DEP51Accident · Minor injuriesClosedCessna 150 · Boscobel, WISep 22, 1976 · N11106 · Destroyed NTSB NYC76FGM50Accident · No injuriesClosedCessna 150L · Beaver Falls, PASep 19, 1976 · N17266 · Substantial damage NTSB OAK76DVA89Accident · No injuriesClosedCessna 150L · Visalia, CASep 14, 1976 · N18014 · Substantial damage NTSB OAK76DVH13Accident · No injuriesClosedCessna 150 · Wolf, CASep 13, 1976 · N5342Q · Destroyed NTSB MKC76DER96Accident · No injuriesClosedCessna 150 · Cambridge, MNSep 6, 1976 · N16078 · Substantial damage NTSB CHI76DBM56Accident · No injuriesClosedCessna 150 · Chesaning, MISep 5, 1976 · N16109 · Substantial damage NTSB SEA76DYIIOAccident · No injuriesClosedCessna 150 · Roseburg, ORSep 2, 1976 · N11758 · Substantial damage NTSB MIA76FKQ48Accident · No injuriesClosedCessna 150L · Meridian, MSAug 29, 1976 · N6647G · Substantial damage NTSB CHI76AC088Accident · 2 fatalClosedCessna 150L · Woodstock, ILAug 25, 1976 · N1452Q · Destroyed NTSB FTW76AF117Accident · 2 fatalClosedCessna 150 · Pflugerville, TXAug 24, 1976 · N11941 · Destroyed NTSB CHI76FEA48Accident · No injuriesClosedCessna 150L · Greenwood, INAug 21, 1976 · N6956G · Substantial damage NTSB MKC76DCQ72Accident · No injuriesClosedCessna 150 · Clyde, KSAug 7, 1976 · N19443 · Substantial damage NTSB ANC76DAH46Accident · No injuriesClosedCessna 150 · Cantwell, AKAug 3, 1976 · N17035 · Substantial damage NTSB MKC76DCQ68Accident · No injuriesClosedCessna 150 · Flush, KSAug 1, 1976 · N19380 · Substantial damage NTSB MKC76DCD59Accident · No injuriesClosedCessna 150 · Leighton, IAAug 1, 1976 · N19153 · Substantial damage NTSB SEA76FYE50Accident · Minor injuriesClosedCessna 150 · Bellevue, WAJul 31, 1976 · N6837G · Destroyed NTSB SEA76FTA26Accident · Serious injuriesClosedCessna 150L · Miles City, MTJul 30, 1976 · N11547 · Destroyed NTSB LAX76FUD11Accident · No injuriesClosedCessna 150 · Compton, CAJul 27, 1976 · N10047 · Substantial damage NTSB NYC76FNA45Accident · No injuriesClosedCessna 150L · Freetown, MAJul 25, 1976 · N6754G · Substantial damage NTSB CHI76FEV54Accident · Minor injuriesClosedCessna 150L · Okawville, ILJul 24, 1976 · N10774 · Substantial damage NTSB NYC76FNC58Accident · No injuriesClosedCessna 150L · Westminster, VTJul 22, 1976 · N5237Q · Substantial damage NTSB DEN76FQA56Accident · Minor injuriesClosedCessna 150 · Tucumcari, NMJul 22, 1976 · N18155 · Substantial damage NTSB MIA76DKJ88Accident · No injuriesClosedCessna 150 · Hazel Green, ALJul 19, 1976 · N5297Q · Substantial damage NTSB OAK76DVD45Accident · No injuriesClosedCessna 150 · Novato, CAJul 17, 1976 · N5330Q · Substantial damage NTSB CHI76FEK22Accident · No injuriesClosedCessna 150L · Celina, OHJul 17, 1976 · N1357Q · Substantial damage NTSB SEA76FTI32Accident · No injuriesClosedCessna 150D · Lincoln, MTJul 14, 1976 · N19422 · Substantial damage NTSB LAX76FVA28Accident · No injuriesClosedCessna 150 · Fullerton, CAJul 14, 1976 · N11497 · Substantial damage NTSB MKC76DER78Accident · No injuriesClosedCessna 150L · Carlton, MNJul 10, 1976 · N1601Q · Substantial damage NTSB MIA76FKQ37Accident · No injuriesClosedCessna A188B · Hollandale, MSJul 9, 1976 · N6694G · Substantial damage NTSB MIA76FLG37Accident · No injuriesClosedCessna 150 · Rock Hill, SCJul 8, 1976 · N18019 · Substantial damage