NTSB investigations: Cessna 150F, CT

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

19672026

NTSB investigations: Cessna 150F, CT per year, 1967–2026: 10 cases
1967	3
1968	2
1969	2
1979	1
1988	1
2002	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 c."eventStateOrRegion" = 'CT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071814')) 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 c.\"eventStateOrRegion\" = 'CT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071814'))
  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 c."eventStateOrRegion" = 'CT' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071814'))
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 IAD02LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Griswold, CTthe pilot's improper pre-flight planning and decision to depart a field with insufficient runway. Factors were the rough/uneven terrain, high obstructions and the tailwind.Jul 5, 2002 · N8894G · Substantial damage NTSB NYC88LA240Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Burlington, CTThe plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of…Sep 24, 1988 · N3099X · Substantial damage NTSB NYC79FNE09Accident · No injuriesClosedCessna 150 · Simsbury, CTFeb 28, 1979 · N6530F · Substantial damage NTSB NYC69D0467Accident · No injuriesClosedCessna 150 · Hartford, CTMay 12, 1969 · N8035S · Substantial damage NTSB NYC69D0430Accident · No injuriesClosedCessna 150 · Southbury, CTApr 28, 1969 · N6703F · Substantial damage NTSB NYC69A0012Accident · 1 fatalClosedCessna 150 · East Hampton, CTJul 31, 1968 · N8121S · Destroyed NTSB NYC68F0506Accident · Serious injuriesClosedCessna 150 · Mansfield, CTJun 5, 1968 · N8112S · Substantial damage NTSB NYC68F0282Accident · No injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N8218F · Substantial damage NTSB NYC68F0280Accident · Serious injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N6694F · Substantial damage NTSB NYC67D0575Accident · No injuriesClosedCessna 150 · Williamantic, CTMar 28, 1967 · N8896G · Substantial damage