NTSB investigations: Cessna 150E, OK

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

19652026

NTSB investigations: Cessna 150E, OK per year, 1965–2026: 12 cases
1965	1
1966	2
1967	2
1968	1
1969	1
1973	1
1978	1
1992	1
2007	1
2022	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" = 'OK' 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 ('2071812')) 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\" = 'OK' 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 ('2071812'))
  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" = 'OK' 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 ('2071812'))
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 CEN22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150E · Harrah, OKThe flight instructor’s inadequate inflight fuel planning that resulted in fuel exhaustion and a forced landing.Jul 1, 2022 · N6147T · Substantial damage NTSB SEA07CA105Accident · No injuriesData collectionFinal reportCessna 150E · Shawnee, OKThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the tree.Apr 18, 2007 · N6251T · Substantial damage NTSB FTW92LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Grove, OKThe pilot failed to maintain aircraft contyrol. A factor was turbulence.Jul 7, 1992 · N3562J · Substantial damage NTSB FTW78FPJ35Accident · Serious injuriesClosedCessna 150 · Lawton, OKAug 3, 1978 · N3955U · Destroyed NTSB FTW74DPM04Accident · No injuriesClosedCessna 150E · Warner, OKAug 4, 1973 · N6251T · Substantial damage NTSB FTW70D0007Accident · No injuriesClosedCessna 150 · Leon, OKMay 31, 1969 · N6184T · Substantial damage NTSB FTW68F0562Accident · Serious injuriesClosedCessna 150E · Oweta, OKApr 25, 1968 · N6102T · Destroyed NTSB FTW68D0286Accident · No injuriesClosedCessna 150 · Okla. City, OKOct 17, 1967 · N3954U · Substantial damage NTSB FTW68D0026Accident · No injuriesClosedCessna 150E · Mill Creek, OKSep 30, 1967 · N6251T · Substantial damage NTSB FTW67D0406Accident · No injuriesClosedCessna 150E · Duncan, OKDec 30, 1966 · N6298T · Substantial damage NTSB FTW67F0328Accident · No injuriesClosedCessna 150E · Mannsville, OKNov 8, 1966 · N6251T · Substantial damage NTSB FTW66D0002Accident · No injuriesClosedCessna 150 · Ardmore, OKMar 3, 1965 · N2578J · Substantial damage