Skip to content

NTSB investigations: Cessna 150G, 1973

47 cases on aircraft the registry lists as Cessna 150G. 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 150G, 1973 per year, 1964–2026: 1,193 cases
1964	1
1966	26
1967	154
1968	122
1969	114
1970	83
1971	78
1972	57
1973	47
1974	30
1975	41
1976	36
1977	22
1978	26
1979	22
1980	24
1981	12
1982	14
1983	15
1984	12
1985	14
1986	8
1987	11
1988	10
1989	8
1990	16
1991	15
1992	11
1993	13
1994	6
1995	10
1996	9
1997	10
1998	9
1999	10
2000	5
2001	8
2002	6
2003	7
2004	4
2005	3
2006	5
2007	4
2008	5
2009	3
2010	5
2011	3
2012	5
2013	4
2014	2
2015	3
2016	2
2017	3
2019	3
2020	1
2021	2
2022	4
2023	3
2024	1
2025	2
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") = 1973 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816')) 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\") = 1973
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
  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") = 1973
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
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 SEA74FTA15Accident · No injuriesClosedCessna 150 · Belle Creek, MTDec 29, 1973 · N2295J · Substantial damage NTSB OAK74DVM15Accident · Minor injuriesClosedCessna 150G · San Jose, CADec 24, 1973 · N2249J · Substantial damage NTSB FTW74AF046Accident · 1 fatalClosedCessna 150G · De Soto, TXDec 22, 1973 · N2227J · Destroyed NTSB LAX74FUG27Accident · No injuriesClosedCessna 150 · Rialto, CANov 23, 1973 · N2978J · Substantial damage NTSB NYC74DHD19Accident · No injuriesClosedCessna 150 · Hammonton, NJNov 3, 1973 · N8561J · Substantial damage NTSB OAK74FVA32Accident · No injuriesClosedCessna 150G · Madera, CANov 1, 1973 · N8618J · Substantial damage NTSB CHI74DEA18Accident · Minor injuriesClosedCessna 150 · Brazil, INOct 27, 1973 · N4027J · Substantial damage NTSB MIA74OKT35Accident · No injuriesClosedCessna 150G · Mores Is, Burkina FasoOct 26, 1973 · N3234X · Substantial damage NTSB MIA74AM035Accident · 1 fatalClosedCessna 150G · Titusville, FLOct 17, 1973 · N1642M · Destroyed NTSB FTW74FPD19Accident · Minor injuriesClosedCessna 150 · Bridgeport, TXOct 14, 1973 · N3657J · Substantial damage NTSB MIA74FKG29Accident · Serious injuriesClosedCessna 150G · Jonesboro, GASep 17, 1973 · N2218J · Substantial damage NTSB NYC74AN022Accident · 1 fatalClosedCessna 172H · Wheeling, ILSep 13, 1973 · N2665L · 2 aircraft · Minor damage NTSB MIA74DLA13Accident · No injuriesClosedCessna 150 · Marianna, FLAug 31, 1973 · N2944J · Substantial damage NTSB OAK74AP009Accident · 2 fatalClosedCessna 150G · S.Francisco, CAAug 27, 1973 · N3705J · Destroyed NTSB NYC74DHM04Accident · No injuriesClosedCessna 150 · Bloomingburg, NYAug 26, 1973 · N2978S · Substantial damage NTSB CHI74FEE11Accident · No injuriesClosedCessna 150 · Wheeling, ILAug 20, 1973 · N3135J · Substantial damage NTSB NYC74DNC17Accident · No injuriesClosedCessna 150G · Wiscasset, MEAug 17, 1973 · N8556J · Substantial damage NTSB OAK74DXQ08Accident · No injuriesClosedCessna 150 · Winnemucca, NVAug 13, 1973 · N6202S · Substantial damage NTSB SEA74FYC09Accident · No injuriesClosedCessna 150 · Baker, ORAug 12, 1973 · N4827X · Substantial damage NTSB NYC74DNA03Accident · No injuriesClosedCessna 150 · N Atlantic Ocean (Atlantic Ocean)Jul 16, 1973 · N8398J · Destroyed NTSB IAD74FKW05Accident · Minor injuriesClosedCessna 150G · Chattanooga, TNJul 14, 1973 · N4733X · Substantial damage NTSB MIA74FKG04Accident · No injuriesClosedCessna 150 · Dalton, GAJul 12, 1973 · N3796J · Substantial damage NTSB IAD74DLQ05Accident · Minor injuriesClosedCessna 150 · Campbellsville, KYJul 7, 1973 · N4746X · Substantial damage NTSB SEA74DYE16Accident · No injuriesClosedCessna 150 · Aldrwood Mnr, WAJun 30, 1973 · N8606J · Minor damage NTSB MIA73DLG52Accident · No injuriesClosedCessna 150 · New Ellenton, SCJun 29, 1973 · N3269J · Substantial damage NTSB DEN73FTE89Accident · Minor injuriesClosedCessna 150 · Holly, COJun 24, 1973 · N2983J · Substantial damage NTSB IAD73FLT19Accident · No injuriesClosedCessna 150 · Covington, TNJun 18, 1973 · N3918J · Substantial damage NTSB NYC73DGM33Accident · No injuriesClosedCessna 150G · Erie, PAJun 2, 1973 · N3203J · Substantial damage NTSB MIA73FLA39Accident · No injuriesClosedOwl-Stol 150 · Palatka, FLMay 27, 1973 · N6358S · Substantial damage NTSB FTW73DRG85Accident · No injuriesClosedRepublic P47D · Harlingen, TXMay 22, 1973 · N47DE · 2 aircraft · Minor damage NTSB FTW73DRD31Accident · No injuriesClosedCessna 150G · Lockport, LAMay 22, 1973 · N4092J · Substantial damage NTSB CHI73FCA05Accident · Minor injuriesClosedCessna 150 · Cahokia, ILMay 18, 1973 · N6272S · Substantial damage NTSB MIA73AM102Accident · 2 fatalClosedCessna 150G · Hiram, GAMay 13, 1973 · N2457J · Destroyed NTSB FTW73FRA27Accident · Serious injuriesClosedCessna 150G · Brenham, TXMay 2, 1973 · N3830J · Substantial damage NTSB NYC73FHD32Accident · Minor injuriesClosedCessna 150G · Rancocas, NJApr 21, 1973 · N3480J · Destroyed NTSB MIA73FLG44Accident · Serious injuriesClosedCessna 150B · Columbia, SCApr 18, 1973 · N2860S · Destroyed NTSB CHI73FEP43Accident · Serious injuriesClosedCessna 150G · Monroe, WIMar 29, 1973 · N2418J · Destroyed NTSB MIA73DLD67Accident · Serious injuriesClosedCessna 150 · Silver Spring, FLMar 28, 1973 · N1641M · Substantial damage NTSB LAX73DUM73Accident · No injuriesClosedCessna 150 · Santee, CAMar 14, 1973 · N3331J · Substantial damage NTSB MIA73FKQ25Accident · Serious injuriesClosedCessna 150 · Avon, MSMar 8, 1973 · N2611J · Substantial damage NTSB LAX73DUG42Accident · No injuriesClosedCessna 150 · Bermuda Dns, CAFeb 27, 1973 · N458AE · Substantial damage NTSB MIA73DKT61Accident · No injuriesClosedCessna 150 · Miami Shores, FLFeb 7, 1973 · N2707S · Substantial damage NTSB NYC73DHJ14Accident · No injuriesClosedCessna 150G · New York City, NYJan 30, 1973 · N6284S · Destroyed NTSB LAX73FUG34Accident · No injuriesClosedCessna 150 · Yucaipa, CAJan 14, 1973 · N2651J · Substantial damage NTSB CHI73AC063Accident · 2 fatalClosedCessna 150G · Berrien Spgs, MIJan 14, 1973 · N4033J · Destroyed NTSB MKC73DER34Accident · No injuriesClosedCessna 150G · Lake Elmo, MNJan 13, 1973 · N2270J · Substantial damage NTSB FTW73AF035Accident · 2 fatalClosedCessna 150G · Manila, ARJan 1, 1973 · N3802J · Destroyed