NTSB investigations: Cessna 150G, OK
31 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.
Cases per year
| 1967 | 7 |
|---|---|
| 1968 | 3 |
| 1969 | 3 |
| 1970 | 4 |
| 1971 | 2 |
| 1975 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2019 | 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 ('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 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 ('2071816'))
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 CEN19LA264Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Cordell, OKThe pilot's improper landing flare, which resulted in a hard bounced landing.NTSB FTW00LA009Accident · Minor injuriesLimited investigationFinal reportCessna 150G · El Reno, OKThe total loss of engine power resulting from a fatigue failure of the intake rocker arm for the #4 cylinder. A factor was the soft terrain encountered during the forced landing.NTSB FTW98LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Claremore, OKThe pilot's failure to maintain obstacle clearance.NTSB FTW91LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · Marietta, OKThe pilot's failure to maintain directional control. A factor was his attempt to takeoff without using all available runway.NTSB FTW89DRJ01Accident · Serious injuriesFinal reportCessna 150 · Piedmont, OKThe pilot's failure to maintain adequate airspeed while buzzing, which resulted in an inadvertent stall.NTSB FTW86FA054Accident · 1 fatalField investigationFinal reportCessna 150G · Salina, OKA night shift worker was returning home in the early morning hours. Crossing the grand river dam near salinas ok. He saw a flash or glint of metal and a large splash near the middle of the widest part of the lake. Examination of the wreckage indicated that…NTSB FTW85LA145Accident · No injuriesLimited investigationFinal reportCessna 150G · Miami, OKStudent pilot was on a solo cross country flight from siloam springs ar. To Miami, ark. And return. The pilot had landed at Miami previously. He had started his takeoff run when a wind gust caused the aircraft to veer left. The aircraft went off the runway…NTSB FTW82DA371Accident · Minor injuriesFinal reportCessna 150 · Tulsa, OKAircraft collided with trees on final after engine quit due to lack of fuel. Aircraft had 1 gallon of fuel on board when it crashed.NTSB FTW82FPJ02Accident · Serious injuriesClosedCessna 150 · Asher, OKNTSB FTW80FPJ32Accident · No injuriesClosedCessna 150G · Norman, OKNTSB FTW79DPJ32Accident · No injuriesClosedCessna 150G · Anadarko, OKNTSB FTW76DPJ04Accident · No injuriesClosedCessna 150G · Marlow, OKNTSB FTW72DPM06Accident · No injuriesClosedCessna 150 · Skiatook, OKNTSB FTW71AF058Accident · 2 fatalClosedCessna 150G · Mcalester, OKNTSB FTW71FPJ24Accident · No injuriesClosedCessna 150 · Wellston, OKNTSB FTW71FPJ23Accident · Serious injuriesClosedCessna 150 · Okla.City, OKNTSB FTW71DPJ06Accident · Minor injuriesClosedCessna 150 · Duncan, OKNTSB FTW70AF071Accident · 1 fatalClosedCessna 150G · Grove, OKNTSB FTW70D0172Accident · No injuriesClosedCessna 150G · Jenks, OKNTSB FTW69D0545Accident · No injuriesClosedCessna 150 · Ardmore, OKNTSB FTW69D0518Accident · No injuriesClosedCessna 150 · Jenks, OKNTSB FTW69F0206Accident · Minor injuriesClosedCessna 150 · Okla.City, OKNTSB FTW69F0124Accident · No injuriesClosedCessna 150 · Beaver, OKNTSB FTW68F0476Accident · No injuriesClosedCessna 150 · Mounds, OKNTSB FTW68D0354Accident · No injuriesClosedCessna 150 · Sand Springs, OKNTSB FTW67F0627Accident · Serious injuriesClosedCessna 150G · Stroud, OKNTSB FTW67F0612Accident · No injuriesClosedCessna 150 · Stillwater, OKNTSB FTW67F0568Accident · No injuriesClosedCessna 150 · Lone Grove, OKNTSB FTW67F0411Accident · Minor injuriesClosedCessna 150 · Jenks, OKNTSB FTW67A0071Accident · 2 fatalClosedCessna 150G · Lawton, OKNTSB FTW67D0362Accident · No injuriesClosedCessna 150 · Stillwater, OK