NTSB investigations: Cessna 150J, UT
12 cases on aircraft the registry lists as Cessna 150J. 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
| 1971 | 2 |
|---|---|
| 1972 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2025 | 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\" = 'UT' 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 ('2071820'))
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" = 'UT' 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 ('2071820'))
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 WPR25LA096Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Minersville, UTThe failure of the propeller blade due to fatigue that originated from an impact pit sustained at an unknown time. Contributing to the accident was the failure of unknown maintenance personnel to detect and repair the impact pit before painting the propeller,…NTSB DEN00LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Spanish Fork, UTThe pilot in command's failure to maintain aircraft directional control.NTSB SEA97LA064Accident · No injuriesLimited investigationFinal reportCessna 150J · Price, UTThe flight instructor's failure to ensure that the dual student maintained adequate airspeed.NTSB SEA95LA166Accident · No injuriesLimited investigationFinal reportCessna 150J · West Jordan, UTThe pilot's failure to refuel the aircraft prior to initiating his cross-country flight resulting in a total power loss due to fuel exhaustion.NTSB DEN87LA165Accident · No injuriesLimited investigationFinal reportCessna 150-J · Ogden, UTThe plt and his son were returning home to Ogden. The plt reported to Ogden tower, 'I'm out of fuel.' The plt later stated, 'I landed in a field of two foot tall grass about five miles north of Ogden arpt. Prior to coming to a stop the acft struck a ditch…NTSB DEN85LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Logan, UTThe acft departed the rwy during a touch and go landing. The plt stated that after touchdown, the acft pulled to the right. The acft impacted a snowbank to adjacent to the rwy and nosed over. It was reported that the plt had applied wheel brakes with the…NTSB DEN78FTM32Accident · Minor injuriesClosedCessna 150 · Heber, UTNTSB DEN78DTM05Accident · No injuriesClosedCessna 150 · Fremont, UTNTSB DEN77FTM04Accident · No injuriesClosedCessna 150J · Kamas, UTNTSB DEN73FTM09Accident · No injuriesClosedCessna 150J · Ogden, UTNTSB DEN72DTM01Accident · No injuriesClosedCessna 150J · Logan, UTNTSB DEN71DTM27Accident · No injuriesClosedCessna 150 · Logan, UT