NTSB investigations: Cessna 150A, 1969

10 cases on aircraft the registry lists as Cessna 150A. 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 150A, 1969 per year, 1964–2026: 132 cases
1964	17
1965	16
1966	21
1967	8
1968	9
1969	10
1970	7
1971	2
1972	1
1973	4
1974	3
1975	4
1976	3
1977	4
1978	3
1979	1
1981	1
1982	1
1983	1
1984	1
1985	1
1991	1
1992	1
1994	1
1995	1
1998	1
2001	1
2007	1
2010	1
2011	1
2013	1
2016	1
2019	1
2022	1
2026	1

Where

Open the map

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") = 1969 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071804')) 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\") = 1969
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071804'))
  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") = 1969
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071804'))
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 LAX70A0032Accident · No injuriesClosedTaylorcraft BC-12D · Santa Paula, CADec 9, 1969 · N39983 · 2 aircraft · Substantial damage NTSB LAX70F0201Accident · Serious injuriesClosedCessna 150 · Sta.Susana, CANov 8, 1969 · N7201X · Destroyed NTSB SEA70F0139Accident · Serious injuriesClosedCessna 150 · Millican, OROct 18, 1969 · N7163X · Destroyed NTSB CHI70A0002Accident · 1 fatalClosedCessna 150 · Odell, ILJul 3, 1969 · N7156X · Destroyed NTSB MIA70D0085Accident · No injuriesClosedCessna 150 · Faunsdale, ALJun 12, 1969 · N7153X · Substantial damage NTSB CHI69F0609Accident · Minor injuriesClosedCessna 150 · Cincinnati, OHMay 4, 1969 · N6620T · Destroyed NTSB NYC70D0060Accident · No injuriesClosedCessna 150 · Rochester, NHApr 4, 1969 · N7157X · Substantial damage NTSB CHI69F0542Accident · No injuriesClosedCessna 150 · Almena, MIMar 17, 1969 · N7071X · Substantial damage NTSB MKC69F0338Accident · No injuriesClosedCessna 150A · Denison, IAFeb 18, 1969 · N7236X · Substantial damage NTSB DIA69A0039Accident · 1 fatalClosedCessna 150 · Flintstone, MDFeb 2, 1969 · N7244X · Destroyed