NTSB investigations: Cessna 150J, NM
15 cases on aircraft the registry lists as Cessna 150J. 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 | 3 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2003 | 1 |
| 2016 | 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 ('2071820'))
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 ('2071820'))
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 GAA16CA267Accident · Minor injuriesData collectionFinal reportCessna 150 · Albuquerque, NMThe student pilot's inadequate preflight inspection/planning, which resulted in fuel exhaustion, loss of engine power, and impact with terrain.NTSB DEN03LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Farmington, NMthe pilot's improper procedures/directives, and the delayed activation of carburetor heat which resulted in the loss of engine power and subsequent impact with terrain. Contributing factors include the carburetor icing conditions, and the rough/uneven and…NTSB FTW94LA255Accident · No injuriesLimited investigationFinal reportCessna 150J · Silver City, NMThe pilot's failure to refuel and the resultant loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW92LA019Accident · No injuriesLimited investigationFinal reportCessna 150J · Hatch, NMFuel exhaustion as a result of the pilot's failure to refuel and his poor preflight and inflight planning. Factors were the unsuitable mountainous terrain at the pilot's disposal and the unfavorable winds aloft.NTSB DEN90LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Las Cruces, NMThe fuel exhaustion induced power loss. Factors were the failure of the pilot to refuel and the high vegetation in which the forced landing was performed.NTSB FTW81FA047Accident · 1 fatalClosedCessna 150 · Fort Sumner, NMNTSB FTW80FQA42Accident · Serious injuriesClosedCessna 150J · Amalie, NMNTSB DEN79FA003Accident · 1 fatalClosedCessna 150J · Eunice, NMNTSB DEN76DQD31Accident · No injuriesClosedCessna 15OJ · Silver City, NMNTSB DEN7LFQD04Accident · No injuriesClosedCessna 150 · Lordsburg, NMNTSB DEN72AD018Accident · 1 fatalClosedCessna 150J · Albuquerque, NMNTSB DEN70FQA26Accident · No injuriesClosedCessna 150 · Albuquerque, NMNTSB DEN70F0131Accident · Minor injuriesClosedCessna 150J · Las Cruces, NMNTSB DEN70D0001Accident · No injuriesClosedCessna 150J · Albuquerque, NMNTSB DEN69D0251Accident · No injuriesClosedCessna 150J · Melrose, NM