NTSB investigations: Cessna 150D, MO
14 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
| 1964 | 3 |
|---|---|
| 1965 | 4 |
| 1966 | 2 |
| 1970 | 1 |
| 1979 | 1 |
| 1986 | 2 |
| 1988 | 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\" = 'MO' 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" = 'MO' 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 MKC88LA153Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Macomb, MOThe acft had been flown 235 nautical miles the previous day without re-fueling. The PIC stated he thought that he could reach his next fuel stop without refueling at the departure arpt. The PIC stated he flew the acft in that gen dirctn for abt 1 hour. At the…NTSB MKC87LA025Accident · No injuriesLimited investigationFinal reportCessna 150 · Nevada, MOThe PIC preflighted his acft prior to departure, but the preflight did not include refueling the acft which contained about 8 gallons of fuel. Normally the 8 gallons of fuel would have been sufficient to reach the destination arpt which was 21 statute miles…NTSB MKC86LA095Accident · No injuriesLimited investigationFinal reportCessna 150D · Marshfield, MOThe pilot stated that the approach speed was faster than normal due to erroneous airspeed indications. The aircraft floated upon flaring and the pilot raised the flaps. He states that the aircraft lost lift, bounced after a hard landing and subsequently…NTSB MKC80FA005Accident · 1 fatalClosedCessna 150D · Stet, MONTSB MKC70FCG18Accident · Serious injuriesClosedCessna 150D · Drexel, MONTSB MKC67D0341Accident · No injuriesClosedCessna 150 · Springfield, MONTSB MKC65F0485Accident · No injuriesClosedCessna 150D · Kennett, MONTSB MKC66F0279Accident · Minor injuriesClosedCessna 150 · Bloomsdale, MONTSB MKC66F0003Accident · Minor injuriesClosedCessna 150 · Columbia, MONTSB MKC65D0071Accident · No injuriesClosedCessna 150 · Holcomb, MONTSB MKC65D0064Accident · Minor injuriesClosedCessna 150 · Columbia, MONTSB UNK65X0975Accident · No injuriesClosedCessna 150 · Blue Springs, MONTSB UNK64X3689Accident · No injuriesClosedCessna 150 · Festus, MONTSB UNK64X3337Accident · Minor injuriesClosedCessna 150 · St Charles, MO