Skip to content

NTSB investigations: Cessna 150L, MA

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

19722026

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 ('2071826')) 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 ('2071826'))
  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 ('2071826'))
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 ERA15CA101Accident · No injuriesData collectionFinal reportCessna 150L · Stow, MAThe flight instructor's delayed remedial action in response to the student pilot's improper go-around, which resulted in the airplane exceeding its critical angle of attack, experiencing an aerodynamic stall, and impacting a parked airplane.Jan 15, 2015 · N5443Q · Substantial damage NTSB ERA11LA383Accident · No injuriesLimited investigationFinal reportCessna 150L · Plymouth, MAA partial loss of engine power during initial climb due to a stuck cylinder valve, which resulted from excessive corrosion and carbon deposits on the valve springs due to inadequate maintenance.Jul 4, 2011 · N150ET · Substantial damage NTSB ERA10CA124Accident · No injuriesData collectionFinal reportCessna 150 · Taunton, MAThe pilot's failure to obtain the proper touchdown point during landing.Jan 26, 2010 · N5478Q · Substantial damage NTSB IAD97LA111Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Westfield, MAThe pilot's inadequate preflight preparation which fail to include a weight and balance check and his subsequent failure to maintain aircraft control.Aug 16, 1997 · N16040 · Substantial damage NTSB NYC95FA224Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Marlborough, MAthe Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.Sep 24, 1995 · N89X · 2 aircraft · Minor damage NTSB BFO92LA119Accident · No injuriesLimited investigationFinal reportCessna 150F · Norfolk, MAThe loss of compression in the no. 4 cylinder due to a valve stuck in the open position, which resulted in the loss of engine power.Jul 30, 1992 · N1073P · Substantial damage NTSB NYC90LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Norfolk, MAThe pilot in command's failure to maintain airspeed during an aborted landing resulting in an inadvertent stall and descent into trees.Aug 20, 1990 · N18147 · Substantial damage NTSB NYC83LNA03Accident · Serious injuriesFinal reportCessna 150 · Stow, MAThe acft propeller struck a passenger who was walking around the acft in preparation for boarding. The acft had been taxied in from landing and stopped near the coffee shop. The wife of the passenger on board the acft approached theacft prior to engine shut…Jul 7, 1983 · N11196 · No damage NTSB NYC83FNA01Accident · 1 fatalFinal reportCessna 150L · Marstons Mills, MAThe acft was observed to climb at a steep angle to 150-200 ft & then enter a spin. The owner/plt had just finished installing stall fences as part of a stol kit that he was in the process of completing. Examination of the acft showed a partial installation of…Dec 2, 1982 · N1433Q · Substantial damage NTSB NYC82DA062Accident · No injuriesFinal reportCessna 150L · Haverhill, MAAfter calling for landing information on UNICOM and receiving no reply the pilot elected to land. During roll-out at approximately 5 mph the aircraft's right main and nose gear encountered a sink-hole causing the right wingtip to hit the ground.Mar 25, 1982 · N10459 · Substantial damage NTSB NYC79FNA31Accident · No injuriesClosedCessna 150L · Tewksbury, MAAug 31, 1979 · N18585 · Substantial damage NTSB NYC79FNA26Accident · No injuriesClosedCessna 150 · North Andover, MAJul 30, 1979 · N10796 · Substantial damage NTSB NYC78DNA18Accident · No injuriesClosedCessna 150 · Newburyport, MAApr 22, 1978 · N7529G · Substantial damage NTSB NYC78DNA16Accident · No injuriesClosedCessna 150 · Marlboro, MAMar 18, 1978 · N1283Q · Substantial damage NTSB NYC78FNE13Accident · No injuriesClosedCessna 150 · Sterling, MAMar 9, 1978 · N10877 · Substantial damage NTSB NYC78FNE11Accident · No injuriesClosedCessna 150 · Shrewsbury, MAFeb 25, 1978 · N7255G · Substantial damage NTSB NYC78DNC16Accident · No injuriesClosedCessna 182 · Bedford, MAFeb 22, 1978 · N19508 · Substantial damage NTSB NYC77FNE31Accident · Minor injuriesClosedCessna 150 · Hampden, MAJul 31, 1977 · N11109 · Substantial damage NTSB NYC76FNA45Accident · No injuriesClosedCessna 150L · Freetown, MAJul 25, 1976 · N6754G · Substantial damage NTSB NYC76AN087Accident · 2 fatalClosedCessna 150L · Plymouth, MAMar 5, 1976 · N19398 · Substantial damage NTSB NYC75FNE28Accident · No injuriesClosedCessna 150L · Worcester, MAFeb 20, 1975 · N10974 · Substantial damage NTSB NYC75FNA25Accident · No injuriesClosedCessna 150L · Millis, MANov 20, 1974 · N6635G · Substantial damage NTSB NYC75DNA04Accident · Minor injuriesClosedCessna 150L · Stow, MAJul 13, 1974 · N11386 · Substantial damage NTSB NYC74FNA28Accident · No injuriesClosedCessna 150L · Lawrence, MADec 2, 1973 · N7529G · Substantial damage NTSB NYC74DNE06Accident · No injuriesClosedCessna 150 · Orange, MASep 16, 1973 · N18637 · Substantial damage NTSB NYC74FNE03Accident · No injuriesClosedCessna 150 · Westfield, MAAug 16, 1973 · N19488 · Substantial damage NTSB NYC73FNE33Accident · No injuriesClosedCessna 150L · Northamton, MAMay 13, 1973 · N18678 · Substantial damage NTSB NYC73AN108Accident · 1 fatalClosedCessna 150 · Taunton, MAFeb 3, 1973 · N5499Q · Destroyed NTSB NYC73FNA07Accident · No injuriesClosedCessna 150L · Chatham, MAJul 24, 1972 · N16007 · Substantial damage NTSB NYC72FNE21Accident · No injuriesClosedCessna 150 · Turnrs Falls, MAJan 1, 1972 · N100FA · Substantial damage