Skip to content

NTSB investigations: Cessna 150G, 1967

154 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, 1967 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") = 1967 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\") = 1967
    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") = 1967
  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 DIA68D0143Accident · No injuriesClosedCessna 150G · Crewe, VADec 31, 1967 · N8535J · Substantial damage NTSB CHI68D0522Accident · No injuriesClosedCessna 150G · Carbondale, ILDec 26, 1967 · N3191J · Substantial damage NTSB NYC68F0322Accident · No injuriesClosedCessna 150G · Hartford, CTDec 20, 1967 · N3237J · Substantial damage NTSB NYC68F0313Accident · No injuriesClosedCessna 150G · Wallkill, NYDec 17, 1967 · N3346J · Substantial damage NTSB MKC68F0391Accident · Minor injuriesClosedCessna 150 · Rosemount, MNDec 16, 1967 · N2484J · Substantial damage NTSB MIA68D0369Accident · No injuriesClosedCessna 150 · Pell City, ALDec 16, 1967 · N3316J · Substantial damage NTSB OAK68D0304Accident · No injuriesClosedCessna 150 · Vacaville, CADec 13, 1967 · N2400J · Substantial damage NTSB CHI68F0446Accident · No injuriesClosedCessna 150G · Ypsilanti, MIDec 13, 1967 · N2776S · Substantial damage NTSB FTW68F0384Accident · No injuriesClosedCessna 150G · Addison, TXDec 12, 1967 · N2731S · Substantial damage NTSB MKC68D0378Accident · No injuriesClosedCessna 150 · Creve Coeur, MODec 6, 1967 · N3457J · Substantial damage NTSB MKC68D0376Accident · No injuriesClosedCessna 150 · Wykoff, MNDec 3, 1967 · N8671J · Substantial damage NTSB NYC68F0329Accident · No injuriesClosedCessna 150G · Bellefonte, PADec 1, 1967 · N904PS · Substantial damage NTSB FTW68F0367Accident · No injuriesClosedCessna 150G · Lancaster, TXNov 27, 1967 · N2880S · Substantial damage NTSB OAK68F0255Accident · Minor injuriesClosedCessna 150 · Kadena, JANov 25, 1967 · N4087J · Destroyed NTSB FTW68D0342Accident · No injuriesClosedCessna 150G · San Antonio, TXNov 25, 1967 · N2632J · Substantial damage NTSB FTW68D0354Accident · No injuriesClosedCessna 150 · Sand Springs, OKNov 20, 1967 · N3288J · Substantial damage NTSB MIA68D0365Accident · No injuriesClosedCessna 150G · Enterprise, ALNov 19, 1967 · N6345S · Substantial damage NTSB UNK68X0107Incident · No injuriesClosedCessna 150F · Livermore, CANov 14, 1967 · N6369S · 2 aircraft · Minor damage NTSB CHI68D0504Accident · No injuriesClosedCessna 150 · Mansfield, OHNov 8, 1967 · N6209S · Substantial damage NTSB MKC68D0277Accident · No injuriesClosedCessna 150 · Hamburg, IANov 6, 1967 · N3128J · Substantial damage NTSB FTW68D0328Accident · No injuriesClosedCessna 150G · Rosenberg, TXNov 5, 1967 · N3340J · Substantial damage NTSB OAK68A0039Accident · 2 fatalClosedCessna 150G · Beckwourth, CANov 3, 1967 · N3704J · Destroyed NTSB MIA68D0304Accident · No injuriesClosedCessna 150 · Davie, FLNov 2, 1967 · N8366J · Substantial damage NTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJOct 29, 1967 · N8398J · 2 aircraft · Substantial damage NTSB OAK68D0181Accident · Minor injuriesClosedCessna 150G · Concord, CAOct 28, 1967 · N4027J · Substantial damage NTSB FTW68F0313Accident · No injuriesClosedCessna 150G · Austin, TXOct 28, 1967 · N3737J · Substantial damage NTSB FTW68D0314Accident · No injuriesClosedCessna 150 · Mcallen, TXOct 28, 1967 · N3725J · Substantial damage NTSB MIA68F0300Accident · No injuriesClosedCessna 150G · W Hollywood, FLOct 25, 1967 · N4744X · Substantial damage NTSB DIA68D0115Accident · No injuriesClosedCessna 150G · Basye, VAOct 24, 1967 · N3711J · Substantial damage NTSB CHI68D0372Accident · No injuriesClosedCessna 150 · Indianapolis, INOct 23, 1967 · N3764J · Substantial damage NTSB NYC68D0263Accident · Minor injuriesClosedCessna 150 · Toms River, NJOct 21, 1967 · N2901S · Substantial damage NTSB LAX68A0041Accident · 4 fatalClosedPiper PA-28 · W.Los Angeles, CAOct 18, 1967 · N5109W · 2 aircraft · Destroyed NTSB DEN68D0111Accident · No injuriesClosedCessna 150 · Pierce, COOct 15, 1967 · N3614J · Substantial damage NTSB CHI68D0390Accident · No injuriesClosedCessna 150 · Streator, ILOct 14, 1967 · N3093S · Substantial damage NTSB FTW68F0282Accident · Minor injuriesClosedCessna 150 · Ferris, TXOct 13, 1967 · N8469J · Destroyed NTSB DEN68F0119Accident · Minor injuriesClosedCessna 150G · Aurora, COOct 10, 1967 · N4077J · Substantial damage NTSB OAK68A0034Accident · 2 fatalClosedCessna 150G · Las Vegas, NVOct 8, 1967 · N3229J · 2 aircraft · Destroyed NTSB LAX68A0039Accident · 2 fatalClosedCessna 150 · Compton, CAOct 6, 1967 · N2967J · Destroyed NTSB DIA68D0080Accident · No injuriesClosedCessna 150 · New Kent, VAOct 3, 1967 · N6287S · Substantial damage NTSB DIA68A0014Accident · 2 fatalClosedCessna 150G · Fincastle, VAOct 2, 1967 · N8665J · Destroyed NTSB OAK68D0140Accident · No injuriesClosedCessna 150 · Lund, NVSep 30, 1967 · N6236S · Substantial damage NTSB MKC68D0272Accident · No injuriesClosedCessna 150G · Worthington, MNSep 28, 1967 · N3365J · Substantial damage NTSB NYC68D0225Accident · Minor injuriesClosedCessna 150 · Pine Plains, NYSep 27, 1967 · N2475J · Substantial damage NTSB OAK68D0200Accident · Minor injuriesClosedCessna 150G · Santa Rosa, CASep 25, 1967 · N3243J · Substantial damage NTSB NYC68D0201Accident · No injuriesClosedCessna 150 · Loganton, PASep 24, 1967 · N2928S · Substantial damage NTSB FTW68F0239Accident · Minor injuriesClosedCessna 150 · Gainesville, TXSep 23, 1967 · N2778S · Substantial damage NTSB MIA68F0144Accident · No injuriesClosedCessna 150G · Centerville, TNSep 16, 1967 · N8349J · Substantial damage NTSB MIA68D0181Accident · No injuriesClosedCessna 150 · Batesville, MSSep 16, 1967 · N2744S · Substantial damage NTSB LAX68F0170Accident · No injuriesClosedCessna 150G · Torrance, CASep 16, 1967 · N8346J · Substantial damage NTSB MIA68F0216Accident · Serious injuriesClosedCessna 150 · Hazel Green, ALSep 13, 1967 · N2206J · Substantial damage