NTSB investigations: Cessna 150H, IA
15 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
| 1969 | 1 |
|---|---|
| 1970 | 3 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 2002 | 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\" = 'IA' 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" = 'IA' 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 CHI02LA240Accident · No injuriesLimited investigationFinal reportCessna 150H · Dyersville, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the bean field.NTSB CHI93LA356Accident · No injuriesLimited investigationFinal reportCessna 150H · Crescent, IAImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.NTSB MKC89LA051Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarion, IAFailure of the pilot to properly use the carburetor heat during icing conditions resulting in carburetor ice formation and subsequent loss of engine power.NTSB MKC87FA077Accident · 1 fatalField investigationFinal reportCessna 150-H · Council Bluffs, IAAcquaintances stated that the student pilot was very motivated in the pursuit of his private pilot certificate and that, on the day of the accident, he was looking forward to this first solo flight. According to his instructor-pilot, who also witnessed the…NTSB MKC77FCD13Accident · Minor injuriesClosedCessna 150H · Belmond, IANTSB MKC77DCD05Accident · No injuriesClosedCessna 150H · Solon, IANTSB MKC75DCD15Accident · No injuriesClosedCessna 150H · Emmetsville, IANTSB MKC74AK004Accident · 2 fatalClosedCessna 150H · Hampton, IANTSB MKC73DCD56Accident · No injuriesClosedCessna 150 · Jefferson, IANTSB MKC73FCD24Accident · No injuriesClosedCessna 150H · Oskaloosa, IANTSB MKC72DCD15Accident · No injuriesClosedCessna 150 · Knoxville, IANTSB MKC71DCD38Accident · No injuriesClosedCessna 150 · Iowa City, IANTSB MKC71DCD29Accident · No injuriesClosedCessna 150H · Center Point, IANTSB MKC70AK072Accident · 2 fatalClosedCessna 150H · Alta, IANTSB MKC70F0290Accident · No injuriesClosedCessna 150H · Winterset, IA