NTSB investigations: Cessna 150H, MN
13 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 | 3 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1985 | 1 |
| 1990 | 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\" = 'MN' 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" = 'MN' 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 CHI90LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hawley, MNThe failure of the PIC to retain control of the airplane during the landing sequence.NTSB CHI85LA220Accident · No injuriesLimited investigationFinal reportCessna 150H · Montevideo, MNThe purpose of the flt was to demonstrate the acft to a possible buyer. While taking off, the eng lost power shortly after the acft lifted off at about mid-field. The plt attempted to turn the acft & land on a cross-runway. However, due to his low speed & low…NTSB MKC75FER67Accident · Minor injuriesClosedCessna 150H · Blaine, MNNTSB MKC74FER11Accident · No injuriesClosedCessna 150H · St Paul, MNNTSB MKC72FER43Accident · No injuriesClosedCessna 150 · Crystal, MNNTSB MKC72DER28Accident · No injuriesClosedCessna 150H · Preston, MNNTSB MKC71FER72Accident · Serious injuriesClosedCessna 150 · Browerville, MNNTSB MKC71FDM43Accident · No injuriesClosedCessna 150H · Rosemount, MNNTSB MKC70FDM14Accident · No injuriesClosedCessna 150 · Lakeville, MNNTSB MKC69D0345Accident · No injuriesClosedCessna 150 · Eden Praire, MNNTSB MKC69D0291Accident · No injuriesClosedCessna 150 · Eden Prairie, MNNTSB MKC68F0578Accident · No injuriesClosedCessna 150H · Rockford, MNNTSB MKC68F0495Accident · No injuriesClosedCessna 150H · Eden Prairie, MN