NTSB investigations: Cessna 150D, AK
8 cases on aircraft the registry lists as Cessna 150D. 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 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2015 | 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\" = 'AK' 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 ('2071810'))
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" = 'AK' 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 ('2071810'))
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 ANC15CA072Accident · No injuriesData collectionFinal reportCessna 150D · Delta Junction, AKThe pilots decision to land on an unfamiliar, unimproved airstrip which resulted in a loss of control and runway excursion.NTSB ANC01LA074Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Soldotna, AKThe loss of engine power due to fuel exhaustion and the pilot's failure to refuel the airplane.NTSB ANC95LA175Accident · No injuriesLimited investigationFinal reportCessna 150 · Coldfoot, AKThe pilot's failure to maintain control of the airplane, while landing.NTSB ANC88LA024Accident · No injuriesLimited investigationFinal reportCessna 150D · Chugiak, AKThe flight instructor stated the student landed back on the runway after a practice engine failure; at that point the flight instructor realized how slick the runway was and the aircraft exited the departure end of the runway into a snow bank.NTSB ANC85LA067Accident · No injuriesLimited investigationFinal reportCessna 150D · Wasilla, AKThe primary cause of this accident was the airplane striking the soft spot on the runway. Underlying factors were the pilot in command's inability to distinguish the soft runway surface from surrounding runway surfaces, and the unusually warm temperatures for…NTSB ANC77FAA34Accident · No injuriesClosedCessna 150 · Koyukuk, AKNTSB ANC71DAG43Accident · No injuriesClosedCessna 150 · Anchor Point, AKNTSB ANC69D0118Accident · No injuriesClosedCessna 150 · Glennallen, AK