Skip to content

NTSB investigations: Cessna 150G, NY

44 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

19662026

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 ('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\" = '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 ('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" = '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 ('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 ERA19LA151Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Fulton, NYA total loss of engine power due to carburetor icing. Contributing was the pilot’s failure to leave the carburetor heat on fully after his initial application of carburetor heat.Apr 11, 2019 · N3795J · Substantial damage NTSB ERA16LA293Accident · No injuriesClass 3 · LimitedFinal reportCessna 150G · Shirley, NYMaintenance personnel’s inadequate maintenance and inspection of the airplane, which resulted in the left elevator attachment bolt backing out of the nutplate, and partial inflight separation and damage of the elevator.Aug 13, 2016 · N3666J · Substantial damage NTSB ERA10CA220Accident · Minor injuriesData collectionFinal reportCessna 150G · Cooperstown, NYA partial loss of engine power during a simulated engine-out demonstration due to carburetor icing.Apr 7, 2010 · N4760X · Substantial damage NTSB ERA09CA270Accident · No injuriesData collectionFinal reportCessna 150G · Kingston, NYThe pilot's failure to maintain clearance from trees during approach.Apr 24, 2009 · N2792S · Substantial damage NTSB IAD00LA084Accident · No injuriesLimited investigationFinal reportCessna 150G · Conesus, NYthe pilot's inadequate preflight performance planning.Sep 19, 2000 · N8376J · Substantial damage NTSB NYC99FA098Accident · 1 fatalField investigationFinal reportCessna 150G · Watertown, NYThe pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.Apr 28, 1999 · N8426J · Substantial damage NTSB NYC96LA042Accident · No injuriesLimited investigationFinal reportCessna 150G · East Hampton, NYfailure of the flight instructor to adequately supervise the dual student pilot and ensure that directional control of the airplane was maintained. The icy runway was a related factor.Dec 23, 1995 · N2970J · Substantial damage NTSB BFO94LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, NYThe pilot's inadequate compensation for the wind conditions and failure to maintain alignment with the runway which resulted in an inflight collision with a tree. A factor is crosswinds.Jun 4, 1994 · N2480J · Destroyed NTSB NYC90LA070Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Duanesburg, NYThe failure of the flight instructor to adequately monitor the actions of the student pilot and apply corrective action in a timely manner.Feb 8, 1990 · N4768X · Substantial damage NTSB NYC88LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Croghan, NYThe pvt plt & one passenger became disoriented while they were on a x-country pleasure flt. The plt was unable to contact any communication center, so she landed in a field & obtained info to get her bearings. She took off again using short/soft field…Oct 13, 1987 · N3497J · Substantial damage NTSB NYC86LA041Accident · No injuriesLimited investigationFinal reportCessna 150G · Palmyra, NYOn landing the acft encountered wind gusts forcing the left wing upward, and hitting the right wing on the ground. The acft then spun around striking the prop and left wing on the rwy.Nov 24, 1985 · N8324J · Substantial damage NTSB NYC83LA116Accident · No injuriesLimited investigationFinal reportCessna 150G · So. Bethlehem, NYThe pilot lost directional control during takeoff. The instructor pilot and student were not injured. The student tried to abort a takeoff when the acft started to swerve left. The instructor tried to correct but had difficulty because of the students input…May 18, 1983 · N3138X · Substantial damage NTSB NYC76DFJ16Accident · No injuriesClosedCessna 150 · West Monroe, NYFeb 12, 1976 · N2985S · Substantial damage NTSB NYC76FFA26Accident · No injuriesClosedCessna 150G · Cadyville, NYJan 21, 1976 · N3274J · Substantial damage NTSB NYC76FHJ08Accident · No injuriesClosedCessna 150G · East Moriches, NYNov 2, 1975 · N3257J · Substantial damage NTSB NYC76DFA15Accident · No injuriesClosedCessna 150 · Plattsburgh, NYSep 20, 1975 · N3274J · Substantial damage NTSB NYC75DFJ26Accident · No injuriesClosedCessna 150G · Farmington, NYJun 17, 1975 · N8324J · Substantial damage NTSB NYC74DFA27Accident · Minor injuriesClosedCessna 150G · Oneonta, NYApr 21, 1974 · N3455J · Substantial damage NTSB NYC74DHM04Accident · No injuriesClosedCessna 150 · Bloomingburg, NYAug 26, 1973 · N2978S · Substantial damage NTSB NYC73DHJ14Accident · No injuriesClosedCessna 150G · New York City, NYJan 30, 1973 · N6284S · Destroyed NTSB NYC72DFJ26Accident · No injuriesClosedCessna 150 · Lockport, NYJan 8, 1972 · N3862J · Substantial damage NTSB NYC72FFJ20Accident · Minor injuriesClosedCessna 150G · Auburn, NYOct 28, 1971 · N4039J · Substantial damage NTSB NYC72DFA15Accident · No injuriesClosedCessna 150 · Selkirk, NYSep 16, 1971 · N2413J · Substantial damage NTSB NYC71DFA61Accident · No injuriesClosedCessna 150 · Johnstown, NYJun 3, 1971 · N2837S · Substantial damage NTSB NYC71DFJ08Accident · No injuriesClosedCessna 150 · Wellsville, NYAug 25, 1970 · N3186X · Substantial damage NTSB NYC71DFA10Accident · No injuriesClosedCessna 150 · Fowler, NYAug 22, 1970 · N3795J · Substantial damage NTSB NYC70AN123Accident · 1 fatalClosedCessna 150G · New Rochelle, NYJun 1, 1970 · N3437J · Destroyed NTSB NYC70DFA10Accident · No injuriesClosedCessna 150 · Gouverneur, NYFeb 28, 1970 · N3795J · Substantial damage NTSB NYC70A0060Accident · 1 fatalClosedCessna 150G · Miller Place, NYDec 4, 1969 · N2924S · Destroyed NTSB NYC70F0204Accident · No injuriesClosedCessna 150 · Canastota, NYNov 18, 1969 · N2448J · 2 aircraft · Substantial damage NTSB NYC70D0061Accident · No injuriesClosedCessna 150 · Busti, NYJul 4, 1969 · N8325J · Substantial damage NTSB NYC69F0401Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYMay 1, 1969 · N248V · Substantial damage NTSB NYC69F0383Accident · Minor injuriesClosedCessna 150G · Milton, NYApr 4, 1969 · N2253J · Substantial damage NTSB NYC69D0381Accident · No injuriesClosedCessna 150 · Weedsport, NYMar 23, 1969 · N3295J · Substantial damage NTSB NYC69F0343Accident · No injuriesClosedCessna 150 · Amityville, NYFeb 27, 1969 · N3063S · Substantial damage NTSB NYC69A0032Accident · 1 fatalClosedCessna 150G · Endicott, NYSep 15, 1968 · N6341S · Substantial damage NTSB NYC68F0324Accident · No injuriesClosedCessna 150 · Leroy, NYJan 2, 1968 · N2260J · Substantial damage NTSB NYC68F0313Accident · No injuriesClosedCessna 150G · Wallkill, NYDec 17, 1967 · N3346J · Substantial damage NTSB NYC68D0225Accident · Minor injuriesClosedCessna 150 · Pine Plains, NYSep 27, 1967 · N2475J · Substantial damage NTSB NYC68D0116Accident · No injuriesClosedCessna 150 · Kerhonkson, NYAug 17, 1967 · N3108J · Substantial damage NTSB NYC68F0038Accident · Minor injuriesClosedCessna 150G · Shirley, NYJun 8, 1967 · N3176X · Substantial damage NTSB NYC67F0601Accident · No injuriesClosedCessna 150G · Castleton Crns, NYApr 8, 1967 · N3607J · Substantial damage NTSB NYC67F0473Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYJan 18, 1967 · N3689J · Substantial damage NTSB NYC67D0432Accident · No injuriesClosedCessna 150 · White Plains, NYDec 18, 1966 · N3190X · Substantial damage