Skip to content

NTSB investigations: Cessna 150F, NM

33 cases on aircraft the registry lists as Cessna 150F. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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 ('2071814')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2071814'))
  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 ('2071814'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 FTW02LA248Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Deming, NMThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat. A contributing factor was the weather conducive to carburetor icing conditions.Sep 2, 2002 · N8351G · Substantial damage NTSB DEN02LA079Accident · No injuriesLimited investigationFinal reportCessna 150F · Grants, NMthe pilot's inadequate preflight preparation, and his failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the high density altitude conditions, the terrain barrier (berm).Jul 18, 2002 · N8067S · Substantial damage NTSB DEN86LA243Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Dexter, NMPlt and pax were taking off from 1900 ft x 50 ft turf rwy 30. Plt said she lifted off at 45 mph and initiated climb of 55 mph. At 250 ft AGL acft suddenly lost 100 ft. acft then went into steep right bank. Acft cleared power lines. Right wing contacted ground…Aug 31, 1986 · N8856S · Destroyed NTSB DEN7LFQA10Accident · Serious injuriesClosedCessna 150 · Corona, NMAug 15, 1975 · N8421G · Substantial damage NTSB DEN73DQA42Accident · No injuriesClosedCessna 150F · Albuquerque, NMMay 24, 1973 · N8182F · Substantial damage NTSB DEN73FQA03Accident · No injuriesClosedCessna 150 · Dulche, NMJun 29, 1972 · N8293S · Substantial damage NTSB DEN72FQA26Accident · No injuriesClosedCessna 150F · Cedar Crest, NMNov 21, 1971 · N8182F · Substantial damage NTSB DEN72FQD10Accident · Minor injuriesClosedCessna 150F · Cloudcroft, NMSep 29, 1971 · N8996S · Substantial damage NTSB DEN72FQA17Accident · No injuriesClosedCessna 150 · Albuquerque, NMAug 27, 1971 · N8682S · Substantial damage NTSB DEN72FQA05Accident · Minor injuriesClosedCessna 150F · Gallup, NMJul 14, 1971 · N6521F · Substantial damage NTSB DEN71FQA46Accident · Serious injuriesClosedCessna 150F · Albuquerque, NMFeb 5, 1971 · N8651S · Substantial damage NTSB DEN69F0125Accident · Serious injuriesClosedCessna 150F · Las Cruces, NMOct 5, 1968 · N7716F · Substantial damage NTSB DEN69F0069Accident · Serious injuriesClosedCessna 150 · Lbuquerque, NMJul 28, 1968 · N7931F · Destroyed NTSB DEN68D0283Accident · No injuriesClosedCessna 150 · Gallup, NMMay 25, 1968 · N7931F · Substantial damage NTSB DEN68D0223Accident · No injuriesClosedCessna 150 · Las Cruces, NMMar 20, 1968 · N3111X · Substantial damage NTSB DEN68F0199Accident · No injuriesClosedCessna 150F · Las Cruces, NMFeb 1, 1968 · N3066X · 2 aircraft · Substantial damage NTSB DEN68D0195Accident · No injuriesClosedCessna 150 · Capitan, NMJan 4, 1968 · N6923F · Substantial damage NTSB DEN68D0155Accident · No injuriesClosedCessna 150 · Albuquerque, NMNov 18, 1967 · N8694G · Substantial damage NTSB DEN68D0153Accident · No injuriesClosedCessna 150 · Columbus, NMNov 10, 1967 · N6297R · Substantial damage NTSB DEN68D0104Accident · No injuriesClosedCessna 150 · Las Cruces, NMOct 4, 1967 · N6442F · Substantial damage NTSB DEN68D0107Accident · No injuriesClosedCessna 150F · Albuquerque, NMSep 28, 1967 · N8713S · Substantial damage NTSB DEN68D0061Accident · No injuriesClosedCessna 150 · Cimarron, NMAug 12, 1967 · N7808F · Substantial damage NTSB DEN68D0058Accident · No injuriesClosedCessna 150 · Springer, NMAug 8, 1967 · N8228F · Substantial damage NTSB DEN68F0030Accident · Minor injuriesClosedCessna 150 · Silver City, NMJun 25, 1967 · N8677S · Substantial damage NTSB DEN67F0258Accident · No injuriesClosedCessna 150F · Albuquerque, NMMar 21, 1967 · N8228F · Substantial damage NTSB FTW67A0066Accident · 1 fatalClosedCessna 150F · Anthony, NMDec 29, 1966 · N6693F · Destroyed NTSB DEN67F0153Accident · No injuriesClosedCessna 150 · Albuquerque, NMNov 19, 1966 · N7931F · Substantial damage NTSB DEN67F0120Accident · No injuriesClosedCessna 150 · Albuquerque, NMOct 3, 1966 · N8228S · Substantial damage NTSB DEN67D0072Accident · No injuriesClosedCessna 150 · Jal, NMAug 5, 1966 · N8208S · Substantial damage NTSB DEN67D0089Accident · No injuriesClosedCessna 150 · Las Cruces, NMJul 30, 1966 · N8006F · Substantial damage NTSB DEN66D0152Accident · No injuriesClosedCessna 150 · Carlsbad, NMNov 6, 1965 · N8931S · Substantial damage NTSB DEN66F0163Accident · Serious injuriesClosedCessna 150F · Zuni, NMOct 18, 1965 · N8859S · Destroyed NTSB DEN66D0136Accident · Minor injuriesClosedCessna 150 · El Rito, NMOct 16, 1965 · N8877S · Destroyed