Skip to content

NTSB investigations: Cessna 150M, MA

21 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

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" = 'MA' 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

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\" = 'MA' 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" = 'MA' 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

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 ERA20FA031Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · New Bedford, MAPilot impairment due to exposure to carbon monoxide as a result of undetected corrosion and holes in the engine’s left exhaust muffler.Nov 4, 2019 · N714LK · Destroyed NTSB ERA16LA300Accident · No injuriesLimited investigationFinal reportCessna 150 · Littleton, MAA total loss of engine power during descent for reasons that could not be determined because postaccident examination of the airframe and engine revealed no anomalies that would have precluded normal operation.Aug 19, 2016 · N9230U · Substantial damage NTSB NYC98FA161Accident · 2 fatalField investigationFinal reportCessna 150M · Worthington, MAThe pilot's failure to maintain airspeed due to diverted attention.Aug 2, 1998 · N704ZY · Destroyed NTSB IAD98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Haverhill, MAA loss of engine power due to a fractured number two cylinder exhaust valve and cracked cylinder. Contributing factors were the operator's allowance of the time between engine overhaul to be exceeded and the trees.Mar 4, 1998 · N63387 · Destroyed NTSB BFO93LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Marlboro, MAThe pilot failed to maintain control of the airplane during landing. Related to the accident was the excessive airspeed.May 9, 1993 · N2894V · Substantial damage NTSB NYC90LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Millis, MAThe pilot's improper use of carburetor heat which caused a power loss and a forced landing in unsuitable terrain. Factors related to the accident were carburetor icing conditions and the pilots lack of total experience.Jan 2, 1990 · N9241U · Substantial damage NTSB NYC90LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Westfield, MALoss of control during landing due to an improper flare and recovery from a bounced landing. A factor relating to the accident was the lack of total experience of the student pilot.Nov 26, 1989 · N704WX · Substantial damage NTSB NYC87LA005Accident · No injuriesLimited investigationFinal reportCessna C-150 · Plymouth, MAThe student pilot flared long during landing and the instructor initiated a go around. During a right turn away from buildings, the aircraft stalled and collided with the ground on its nose and flipped over.Oct 3, 1986 · N704PY · Substantial damage NTSB NYC81FNE15Accident · Minor injuriesClosedCessna 150 · Belchertown, MAApr 7, 1981 · N9213U · Substantial damage NTSB NYC80FNE12Accident · No injuriesClosedCessna 150 · Hardwick, MAMar 17, 1980 · N9283U · Substantial damage NTSB NYC79FNA21Accident · No injuriesClosedCessna 150M · Middleboro, MAJul 10, 1979 · N66349 · Substantial damage NTSB NYC79FNE01Accident · Minor injuriesClosedCessna 150 · Monson, MADec 8, 1978 · N45352 · Substantial damage NTSB NYC78FA089Accident · 2 fatalClosedCessna 150M · Millbury, MASep 9, 1978 · N9470U · Destroyed NTSB NYC78FNA04Accident · No injuriesClosedCessna 150 · Mansfield, MAOct 29, 1977 · N9470U · Substantial damage NTSB NYC77DNA17Accident · No injuriesClosedCessna 150 · Haverhill, MAMay 22, 1977 · N714SS · Substantial damage NTSB NYC77FA036Accident · 1 fatalClosedCessna 150M · Fitchburg, MAMar 12, 1977 · N8650U · Substantial damage NTSB NYC77FNE10Accident · No injuriesClosedCessna 150 · Hopedale, MAMar 3, 1977 · N714CP · Substantial damage NTSB NYC76DNA35Accident · No injuriesClosedCessna 150 · Norfolk, MAApr 20, 1976 · N63439 · Substantial damage NTSB NYC76AN029Accident · No injuriesClosedCessna 150 · Fitchburg, MAAug 28, 1975 · N3888V · 2 aircraft · Substantial damage NTSB NYC75FNE23Accident · Serious injuriesClosedCessna 150M · Southampton, MADec 31, 1974 · N66284 · Substantial damage NTSB UNK64X4021Accident · No injuriesClosedCessna 172A · Beverly, MASep 17, 1964 · N9712T · Minor damage