NTSB investigations: Cessna 150, WA
19 cases on aircraft the registry lists as Cessna 150. 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
| 1964 | 2 |
|---|---|
| 1965 | 3 |
| 1966 | 3 |
| 1968 | 2 |
| 1970 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 'WA' 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 ('2071802'))
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" = 'WA' 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 ('2071802'))
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 SEA07CA078Accident · No injuriesData collectionFinal reportCessna 150A · Davenport, WAThe pilot's failure to maintain directional control while landing, which resulted in a nose over. Wind gusts and the pilot's inadequate compensation for the wind condition were factors.NTSB SEA06LA053Accident · Serious injuriesLimited investigationFinal reportCessna 150 · White Salmon, WAThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. Contributing factors were the inadequate preflight by the pilot, and the airplane's fuel contamination by water.NTSB SEA98LA093Accident · 1 fatalLimited investigationFinal reportCessna 150 · Amboy, WAThe pilot's failure to maintain adequate altitude and/or clearance from terrain during a go-around attempt. Factors included a short landing area and trees in the landing area.NTSB SEA94LA091Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Woodland, WAAirspeed was not maintained.NTSB SEA86LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fall City, WADuring an attempted go around the acft struck trees and bushes. The plt stated he could not remember if carb heat was removed during the go around. He continued to state, sufficient alt and airspeed could not be gained. An eng examination revealed several…NTSB SEA77DYE10Accident · No injuriesClosedCessna 150 · Gardiner, WANTSB SEA76FYG63Accident · No injuriesClosedCessna 150 · Mead, WANTSB SEA76DYC25Accident · No injuriesClosedCessna 150 · Vancouver, WANTSB SEA70DWG05Accident · No injuriesClosedCessna 150 · Pomeroy, WANTSB SEA69D0136Accident · No injuriesClosedCessna 150 · Long Beach, WANTSB SEA68D0247Accident · No injuriesClosedCessna 150 · Yakima, WANTSB SEA67D0014Accident · No injuriesClosedCessna 150 · Richland, WANTSB SEA67F0043Accident · No injuriesClosedCessna 150 · Chehalis, WANTSB SEA66F0253Accident · Serious injuriesClosedCessna 150 · Seattle, WANTSB SEA66F0193Accident · No injuriesClosedCessna 150 · Ellensburg, WANTSB SEA66D0101Accident · Minor injuriesClosedCessna 150 · Dalkena, WANTSB UNK65X1252Accident · No injuriesClosedCessna 150 · Ellensburg, WANTSB UNK65X0474Accident · Minor injuriesClosedCessna 150 · Medical Lake, WANTSB UNK64X3679Accident · 1 fatalClosedCessna 150 · Renton, WA