NTSB investigations: Cessna 150F, ID
16 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.
Cases per year
| 1966 | 2 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1973 | 2 |
| 1975 | 2 |
| 1978 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 2024 | 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\" = 'ID' 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" = 'ID' 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" 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 WPR25LA283Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Rigby, IDThe flight instructor’s improper flap position during takeoff, which resulted in degraded climb performance and a subsequent impact with a building.NTSB WPR24LA149Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Bonners Ferry, IDThe student pilot’s failure to maintain control of the airplane during landing in gusting wind conditions.NTSB SEA85LA068Accident · No injuriesLimited investigationFinal reportCessna 150F · Nampa, IDWhile flying at ngt in the LCL practice area south of Nampa, the plt thought he had flown into IMC, but the wx was good. He was unable to see the ground, so he made a 180 deg turn, then noted problems seeing his instrument panel. Suspecting psbl carbon…NTSB SEA81FYA06Accident · Serious injuriesClosedCessna 150F · Caldwell, IDNTSB SEA78FYP54Accident · Minor injuriesClosedCessna 150 · Coeur D'Alene, IDNTSB SEA76DYA12Accident · No injuriesClosedCessna 175 · Yellow Pine, IDNTSB SEA76DYA10Accident · No injuriesClosedCessna 150 · Jerome, IDNTSB SEA74DYA16Accident · No injuriesClosedCessna 150F · Rexburg, IDNTSB SEA73DYA24Accident · Minor injuriesClosedCessna 150F · Pine, IDNTSB SEA70FXM04Accident · No injuriesClosedCessna 150 · Boise, IDNTSB SEA70D0091Accident · No injuriesClosedCessna 150 · Idaho Falls, IDNTSB SEA70D0043Accident · Serious injuriesClosedCessna 150 · Grangeville, IDNTSB SEA69D0116Accident · No injuriesClosedCessna 150 · Orofino, IDNTSB SEA68D0145Accident · No injuriesClosedCessna 150 · Rexburg, IDNTSB SEA67D0177Accident · No injuriesClosedCessna 150 · Twin Falls, IDNTSB SEA66F0233Accident · No injuriesClosedCessna 150 · Boise, ID