NTSB investigations: Cessna 150H, OK
13 cases on aircraft the registry lists as Cessna 150H. 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.
Cases per year
| 1968 | 2 |
|---|---|
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 2021 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2071818'))
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 ('2071818'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN21LA408Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Heavener, OKA total loss of engine power due to the failure of the No. 2 cylinder exhaust valve for reasons that could not be determined.NTSB FTW95LA318Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Muskogee, OKThe pilot's evasive manuever to take off with insufficient runway available for attaining takeoff airspeed. Factors which contributed to the accident were: the unauthorized use of the airplane, the pilot's anxiety, and the dark night.NTSB MKC89FA102Accident · 2 fatalField investigationFinal reportCessna 150H · Carnegie, OKContinued VFR flight by the pilot into instrument meteorological conditions, which resulted in subsequent collision with rising/hilly terrain. Related factors were: inadequate preflight planning/preparation by the pilot, dark night, adverse weather…NTSB FTW86LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Bartlesville, OKThe plt took off on a test flt after an annual inspn of the acft & a top overhaul of the eng had been completed. While climbing thru about 1200 to 1300 ft AGL, the eng started running rough, then quit. The plt attempted to return to the arpt, but was unable.…NTSB FTW81FPJ20Accident · Minor injuriesClosedCessna 150 · Dover, OKNTSB FTW79FPM10Accident · No injuriesClosedCessna 150 · Vinita, OKNTSB FTW78FPM12Accident · No injuriesClosedCessna 150 · Owasso, OKNTSB FTW74AF061Accident · 2 fatalClosedCessna 150 · Boise City, OKNTSB FTW73FPJ11Accident · No injuriesClosedBeech 95-C55 · Norman, OKNTSB FTW72DPJ07Accident · Minor injuriesClosedCessna 150H · Okene, OKNTSB FTW70F0286Accident · Serious injuriesClosedCessna 150 · Purcell, OKNTSB FTW69D0188Accident · No injuriesClosedCessna 150 · Norman, OKNTSB FTW68A0091Accident · 1 fatalClosedCessna 150H · Norman, OK