NTSB investigations: Cessna 150G, NM

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

19682026

NTSB investigations: Cessna 150G, NM per year, 1968–2026: 10 cases
1968	1
1969	2
1971	1
1972	1
1975	1
1976	1
1978	1
1979	1
2026	1

Where

Open the map

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 ('2071816')) 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 ('2071816'))
  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 ('2071816'))
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 WPR26LA325Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150 · Socorro, NMAug 17, 2026 · N2970S · Substantial damage NTSB DEN79DQA17Accident · No injuriesClosedCessna 150 · Farmington, NMFeb 9, 1979 · N3363J · Substantial damage NTSB DEN78FQA38Accident · No injuriesClosedCessna 150G · Albuquerque, NMJul 10, 1978 · N3643J · Substantial damage NTSB DEN77FQA01Accident · No injuriesClosedCessna 150 · Valencia, NMOct 5, 1976 · N3643J · Substantial damage NTSB DEN75FQA27Accident · No injuriesClosedCessna 150 · Las Vegas, NMJan 18, 1975 · N8694J · Substantial damage NTSB DEN73FQA10Accident · No injuriesClosedCessna 150 · Albuquerque, NMAug 12, 1972 · N3137X · Substantial damage NTSB DEN71AD034Accident · 2 fatalClosedCessna 150G · Berino, NMFeb 17, 1971 · N4663X · Destroyed NTSB DEN70D0080Accident · No injuriesClosedCessna 150G · Capitan, NMSep 1, 1969 · N8691J · Destroyed NTSB DEN69D0220Accident · No injuriesClosedCessna 150 · Espanola, NMApr 22, 1969 · N2955S · Substantial damage NTSB DEN68F0279Accident · Minor injuriesClosedCessna 150G · Pinon, NMMay 26, 1968 · N4792X · Substantial damage