NTSB investigations: Cessna 150H, OR
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
| 1968 | 3 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1974 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 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\" = 'OR' 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" = 'OR' 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 SEA00LA176Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ontario, ORThe pilot-in-command/flight instructor's failure to adequately refuel the aircraft, resulting in fuel exhaustion, and his subsequent high flare in a forced landing attempt, resulting in a stall and touchdown/impact on the nose gear.NTSB SEA97LA124Accident · No injuriesLimited investigationFinal reportCessna 150H · Redmond, ORthe pilot's improper decision to depart on a flight without first ensuring the aircraft held sufficient fuel to reach his destination, which resulted in fuel exhaustion. Factors were the high vegetation and rocks at the location of the forced landing.NTSB SEA95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Albany, ORThe pilot's failure to use carburetor heat. Factors include icing conditions and the dark night light conditions.NTSB SEA91FA095Accident · 1 fatalField investigationFinal reportCessna 150H · Sumpter, ORThe pilot's improper inflight planning and decisions and the pilot's VFR flight into IMC conditions.NTSB SEA82FA064Accident · 2 fatalField investigationFinal reportCessna 150H · Oregon City, ORThe aircraft crashed during takeoff from a private airport that was not open to the public. Operations on the airport were at the owner's discretion (prior permission required). An electric fence crossed the airport about 1500 ft from the south end. The owner…NTSB SEA81FA048Accident · 2 fatalClosedCessna 150H · Blue River, ORNTSB SEA77DYM51Accident · No injuriesClosedCessna 150 · Dallas, ORNTSB SEA75DYC20Accident · No injuriesClosedCessna 150 · St Paul, ORNTSB SEA72FYC25Accident · No injuriesClosedCessna 150 · Forest Grove, ORNTSB SEA71FVQ21Accident · Serious injuriesClosedCessna 150H · Cotage Grove, ORNTSB SEA70DXM08Accident · No injuriesClosedCessna 150H · Lagrande, ORNTSB SEA69F0214Accident · Minor injuriesClosedCessna 150H · Medford, ORNTSB SEA69D0176Accident · No injuriesClosedCessna 150 · Chemult, ORNTSB SEA69F0073Accident · Serious injuriesClosedCessna 150 · The Dalles, ORNTSB SEA69D0042Accident · Minor injuriesClosedCessna 150 · Halfway, OR