NTSB investigations: Cessna 150M, MD
10 cases on aircraft the registry lists as Cessna 150M. 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
| 1975 | 1 |
|---|---|
| 1976 | 2 |
| 1978 | 2 |
| 1979 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1999 | 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\" = 'MD' 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 ('2071830'))
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" = 'MD' 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 ('2071830'))
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 ERA15LA368Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Airy, MDThe in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.NTSB IAD99FA069Accident · Serious injuriesField investigationFinal reportCessna 150M · Ellicott City, MDthe flight instructor's failure to follow the balked landing procedure in the owner's manual by retracting the flaps from 40 degrees to zero degrees.NTSB NYC84FA218Accident · 1 fatalField investigationFinal reportCessna 150M · Keymar, MDWitness stated acft was performing touch & go landings. On third or forth initial climb at about 300 ft AGL the acft began 'zigzagging.' The acft then entered a nose low atitude and descended to ground impact aprx 1/2 mile from the arpt. Inspection of…NTSB ATL83FA045Accident · Serious injuriesField investigationFinal reportCessna 150M · Edgewater, MDApproximately 45 min after takeoff, the eng started to run rough. The plt headed toward the nearest arpt with the eng still running rough. The plt entered downwind & proceeded to follow a normal landing pattern. As he turned final, the eng quit completely.…NTSB IAD79FIG13Accident · No injuriesClosedCessna 150 · Westminster, MDNTSB IAD79FIG02Accident · Serious injuriesClosedCessna 150 · Elkton, MDNTSB IAD79FIG01Accident · No injuriesClosedCessna 150 · Fort Meade, MDNTSB IAD77DIG03Accident · No injuriesClosedCessna 150 · Easton, MDNTSB IAD76FIA10Accident · Minor injuriesClosedCessna 150M · College Park, MDNTSB IAD76FIG02Accident · Minor injuriesClosedCessna 150 · Rising Sun, MD