Skip to content

NTSB investigations: Cessna 150M, PA

25 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

19752026

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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 ERA24LA101Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150M · Franklin, PAThe pilots’ inadequate preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jan 15, 2024 · N7682U · Substantial damage NTSB NYC08CA010Accident · No injuriesData collectionFinal reportCessna 150M · Palmyra, PAThe student pilot's improper recovery from a bounced landing, and the CFI's failure to take remedial action.Oct 8, 2007 · N6252K · Substantial damage NTSB NYC06CA094Accident · No injuriesData collectionFinal reportCessna 150M · Hazleton, PAThe student pilot's improper recovery from a bounced landing, resulting in a hard landing.Mar 30, 2006 · N704MT · Substantial damage NTSB NYC01LA003Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Haverford Twp., PAA loss of engine power due to fuel exhaustion. Also causal was the pilot's inability to locate the airport. A factor in this accident was the dark night conditions.Oct 5, 2000 · N704ST · Substantial damage NTSB BFO95LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Erie, PAThe loss of engine power for undetermined reasons.Apr 1, 1995 · N3546V · Substantial damage NTSB NYC93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Dowingtown, PAThe loss of engine power for undetermined reasons.Apr 9, 1993 · N6340K · Substantial damage NTSB NYC87LA078Accident · No injuriesLimited investigationFinal reportCessna 150C · Downingtown, PAA precautionary landing was made in a snow covered level field due to a loss of power for unknown reasons. The aircraft was substantially damaged.Feb 7, 1987 · N66270 · Substantial damage NTSB NYC85LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeannette, PAAfter returning to the arpt, the plt made a night landing in light & variable wind conditions. During the landing, the acft drifted left of the centerline, encountered snow & ice, & subsequently hit a snowbank & nosed over.Feb 21, 1985 · N3912V · Substantial damage NTSB NYC84LA217Accident · No injuriesLimited investigationFinal reportCessna 50M · Middletown, PAThe solo student plt was approaching the rwy to make a landing when the twr gave him go-around instructions due to an shorts 3-30 acft on final. During the go-around the student said he encountered wake turbulence. The acft cartwheeled and came to rest with…Jun 22, 1984 · N704UL · Destroyed NTSB NYC83LA200Accident · No injuriesLimited investigationFinal reportCessna 150M · St. Clair, PAThe student plt was on a x-country flt when he encountered reduced visibility with fog & haze. He tried to locate an arpt by flying time & distance off of a VOR station. He circled in the vicinity of where he thought the arpt was at, then elected to land…Aug 7, 1983 · N707CF · Substantial damage NTSB NYC82DA119Accident · No injuriesFinal reportCessna 150M · Perkasie, PADuring a local flight, the student pilot elected to proceed to Perkasie, PA to practice landings. The pilot reported that when he flared for a landing, he brought the nose up too high and then overcompensated. When he lowered the nose, the aircraft touched…Jun 8, 1982 · N3670V · Substantial damage NTSB NYC81FGT07Accident · Minor injuriesClosedCessna 150 · Columbia, PAJul 8, 1981 · N76CA · Destroyed NTSB NYC80FGT06Accident · No injuriesClosedCessna 150M · Thomasville, PAFeb 27, 1980 · N704HV · Substantial damage NTSB NYC80FGM10Accident · No injuriesClosedCessna 150M · Waynesburg, PAJan 26, 1980 · N704ST · Substantial damage NTSB NYC79FGT21Accident · No injuriesClosedCessna 150 · Atglen, PASep 15, 1979 · N2876V · Substantial damage NTSB UNK79X0114Accident · Minor injuriesClosedCessna 150 · Willow Grove, PAJul 26, 1979 · N63150 · Destroyed NTSB NYC79FGM15Accident · No injuriesClosedCessna 150 · Belle Vernon, PAFeb 11, 1979 · N9377U · Substantial damage NTSB NYC78FA086Accident · No injuriesClosedCessna 150 · Duncannon, PAAug 27, 1978 · N714CR · Substantial damage NTSB NYC78FA049Accident · Serious injuriesClosedCessna 150M · West Chester, PAMay 7, 1978 · N63176 · Destroyed NTSB NYC78FGM18Accident · No injuriesClosedCessna 150M · Waynesburg, PAFeb 19, 1978 · N45080 · Substantial damage NTSB NYC78FHA03Accident · Minor injuriesClosedCessna 150M · Bethel, PANov 1, 1977 · N714HG · Destroyed NTSB NYC77DHD31Accident · No injuriesClosedCessna 150 · Blue Bell, PASep 12, 1977 · N63176 · Substantial damage NTSB NYC77FHD01Accident · No injuriesClosedCessna 150 · West Chester, PAOct 16, 1976 · N63150 · Substantial damage NTSB NYC76DHA35Accident · No injuriesClosedCessna 150 · Tunkhannock, PAJun 5, 1976 · N3092V · Substantial damage NTSB NYC75FHD41Accident · No injuriesClosedCessna 150M · New London, PAApr 13, 1975 · N3156V · Substantial damage