NTSB investigations: Cessna 150M, NM
11 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
| 1976 | 2 |
|---|---|
| 1980 | 3 |
| 1982 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1997 | 2 |
| 2013 | 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\" = 'NM' 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" = 'NM' 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 CEN13LA179Accident · 1 fatalLimited investigationFinal reportCessna 150M · Deming, NMThe pilot's physical incapacitation, including loss of vision, which led to a loss of control and the subsequent in-flight breakup of the airplane.NTSB FTW98LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Tajique, NMThe loss of engine power due to carburetor ice. Factors included unsuitable terrain, and dark night conditions.NTSB FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.NTSB DEN88LA171Accident · No injuriesLimited investigationFinal reportCessna 150 · Albuquerque, NMThe instructor (CFI) & student plt were on an instructional flt. The CFI rprtd that while climbing thru aprx 150' AGL, the acft enctrd a downdraft. He took the controls, but the acft descended to about 10 ft AGL. The CFI elected to land immediately to avoid a…NTSB DEN85LQA05Accident · No injuriesFinal reportCessna 150M · Santa Fe, NMThe plt experienced a hard landing while on a solo x-country flt. The plt reported the flt had been delayed until mid-afternoon because of mechanical problems at by that time the winds had picked up. The student plt also reported having little dual experience…NTSB FTW82FQA26Accident · Serious injuriesFinal reportCessna 150 · La Plata, NMAcft struck a power line which crossed a road at about 40 ft AGL. The acft was observed flying at low altitude in the area prior to the accident.NTSB FTW80FQA43Accident · No injuriesClosedCessna 150M · Albuquerque, NMNTSB FTW80FQA29Accident · Minor injuriesClosedCessna 150 · Gallup, NMNTSB DEN80DQA22Accident · No injuriesClosedCessna 150 · Duran, NMNTSB DEN77FA002Accident · 2 fatalClosedCessna 150 · Texico, NMNTSB DEN76DQD21Accident · No injuriesClosedCessna 150 · Silver City, NM