Skip to content

NTSB investigations: Cessna 150J, NY

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

19692026

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" = 'NY' 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 ('2071820')) 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\" = 'NY' 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 ('2071820'))
  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" = 'NY' 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 ('2071820'))
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 ERA17LA120Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Argyle, NYA total loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.Mar 5, 2017 · N60939 · Substantial damage NTSB IAD03LA034Accident · No injuriesLimited investigationFinal reportCessna 150J · Williamson, NYThe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor was the snow-covered runway.Feb 25, 2003 · N51126 · Substantial damage NTSB NYC96FA078Accident · 1 fatalField investigationFinal reportCessna 150J · Warwick, NYthe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion. A related factor was the pilot's lack of recent experience.Mar 24, 1996 · N5587G · Destroyed NTSB NYC92LA032Accident · No injuriesLimited investigationFinal reportCessna 150 · Poestenskill, NYThe pilot's improper use of carburator heat, resulting in carburator ice and a loss of engine power and subsequent forced landing on unsuitable terrain.Nov 16, 1991 · N50877 · Substantial damage NTSB NYC91LA089Accident · No injuriesLimited investigationFinal reportCessna 150J · Angola, NYThe failure of the pilot to insure the magneto switch was off prior to moving the propeller.Mar 13, 1991 · N51396 · Substantial damage NTSB NYC88FA193Accident · 1 fatalField investigationFinal reportCessna 150J · Palmyra, NYCessna N51413 departed Palmyra airpark with full flaps and crashed into a barn about 75 feet past the departure end of runway 35. Afterward, the flap actuator was found in the flap up position. The pilot said that the engine lost 200 to 300 RPM about 300 feet…Jul 25, 1988 · N51413 · Destroyed NTSB NYC87LA183Accident · No injuriesLimited investigationFinal reportCessna 150J · Olcott, NYA student pilot practicing touch and go landings experienced an engine power loss on takeoff. During an approach to an open field for an emergency landing, the engine restarted. The pilot decided to return to the arpt. Upon entering downwind, the engine quit.…Jun 24, 1987 · N51333 · Substantial damage NTSB NYC87LA145Accident · No injuriesLimited investigationFinal reportCessna 150 · Stanford, NYDuring enroute flight from rock island, providence to lincoln park, an engine power loss was experienced. In addition the pilot stated that he had become lost and disoriented due to darkness. When the aircraft started to descend, the pilot looked for a spot…May 12, 1987 · N50682 · Substantial damage NTSB NYC87LA048Accident · No injuriesLimited investigationFinal reportCessna 150 · Poestenkill, NYThe pilot touched down hard, added power for a go around. Sluggish engine did not have enough power to clear trees at the end of the runway. Aircraft collided with trees. The plt after the acc said that after cutting off the carb head the eng seemed sluggish.…Dec 6, 1986 · N50714 · Substantial damage NTSB NYC87LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · So. Dayton, NYThe student pilot came in long and high, bounced the aircraft a few times. The nose wheel collpased and the aircraft was substantially damaged.Oct 7, 1986 · N50832 · Substantial damage NTSB NYC86LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Syracuse, NYDuring descent about six miles from Syracuse hancock airport, the flight experienced engine vibration. Engine lost power and restarted. However when flight was at 3500 feet, power was lost again. Pilot set up for best glide and crashed in a grassy field. Full…Jun 3, 1986 · N61316 · Substantial damage NTSB NYC81FHJ13Accident · Minor injuriesClosedCessna 150 · Shelter Island, NYAug 23, 1981 · N5590G · Substantial damage NTSB NYC78FA039Accident · Minor injuriesClosedCessna 150J · Ronkonkoma, NYApr 1, 1978 · N50847 · Destroyed NTSB NYC78FHJ07Accident · No injuriesClosedCessna 150 · Bayport, NYFeb 25, 1978 · N60616 · Substantial damage NTSB NYC77FFJ39Accident · No injuriesClosedCessna 150J · Binghamton, NYAug 8, 1977 · N50740 · Substantial damage NTSB NYC77FHG19Accident · No injuriesClosedPiper PA-28 · Amityville, NYMay 1, 1977 · N33770 · 2 aircraft · Substantial damage NTSB NYC76AN116Accident · 1 fatalClosedCessna U206F · Syosset, NYJul 26, 1976 · N35946 · 2 aircraft · Substantial damage NTSB NYC76DFJ11Accident · Minor injuriesClosedCessna 150 · Lockport, NYOct 23, 1975 · N5564G · Substantial damage NTSB NYC75FFJ10Accident · Minor injuriesClosedCessna 150 · Gasport, NYSep 5, 1974 · N60658 · Substantial damage NTSB NYC75AN027Accident · 1 fatalClosedCessna 150J · Dryden, NYSep 1, 1974 · N60394 · Destroyed NTSB NYC74DHJ15Accident · No injuriesClosedCessna 150 · Deerpark, NYSep 9, 1973 · N60616 · 2 aircraft · Substantial damage NTSB NYC73FFJ14Accident · Minor injuriesClosedCessna 150J · Brockport, NYNov 21, 1972 · N61103 · Substantial damage NTSB NYC73FFJ09Accident · No injuriesClosedCessna 150 · Brockport, NYSep 16, 1972 · N60950 · Substantial damage NTSB NYC72DFJ36Accident · No injuriesClosedCessna 150 · Newfane, NYApr 9, 1972 · N60643 · Substantial damage NTSB NYC72FFJ24Accident · No injuriesClosedCessna 150J · Buffalo, NYJan 6, 1972 · N60658 · Substantial damage NTSB NYC71FFJ38Accident · No injuriesClosedCessna 150J · Bergholtz, NYJun 30, 1971 · N50832 · Substantial damage NTSB NYC71DFA36Accident · No injuriesClosedCessna 150J · Cobleskill, NYJan 17, 1971 · N61114 · Substantial damage NTSB NYC71FFA03Accident · No injuriesClosedCessna 150 · Ballston Spa, NYJul 17, 1970 · N51245 · Substantial damage NTSB NYC70FHJ10Accident · Minor injuriesClosedCessna 150 · Farmingdale, NYJun 9, 1970 · N60520 · Substantial damage NTSB NYC70DFJ08Accident · No injuriesClosedCessna 150 · Seneca Falls, NYMar 25, 1970 · N61103 · Substantial damage NTSB NYC70DHJ07Accident · Minor injuriesClosedCessna 150J · E Hampton, NYMar 16, 1970 · N50475 · Substantial damage NTSB NYC70DFJ03Accident · No injuriesClosedCessna 150 · Camillus, NYJan 24, 1970 · N51109 · Substantial damage NTSB NYC70FFA01Accident · No injuriesClosedCessna 150 · Philmont, NYJan 2, 1970 · N60476 · Substantial damage NTSB NYC70A0056Accident · 1 fatalClosedCessna 150 · La Grangeville, NYNov 29, 1969 · N61086 · Destroyed NTSB NYC69D0426Accident · No injuriesClosedCessna 150 · Warwick, NYApr 1, 1969 · N50728 · Substantial damage