Skip to content

NTSB investigations: Cessna 150F, NY

58 cases on aircraft the registry lists as Cessna 150F. 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 ('2071814')) 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 ('2071814'))
  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 ('2071814'))
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 ERA11CA217Accident · No injuriesData collectionFinal reportCessna 150F · Hannawana Falls, NYThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Mar 26, 2011 · N8830G · Substantial damage NTSB NYC03LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Williamson, NYThe failure of a rocker arm shaft boss, which resulted in a partial loss of power and subsequent forced landing. A factor was the unsuitable terrain.Jun 26, 2003 · N8517G · Substantial damage NTSB NYC92FA062Accident · 1 fatalField investigationFinal reportCessna 150 · White Lake, NYThe pilot's improper decision to fly into known adverse weather conditions, his failure to maintain control of the airplane, and his impairment of judgement due to drugs. Factors which contributed to the accident were: the dark night, the adverse weather…Feb 16, 1992 · N6559F · Substantial damage NTSB NYC90FA083Accident · 1 fatalField investigationFinal reportCessna 150F · Lloyd, NYPilot factor in that he was attempting VFR flight in inc conditions and collided with a multipurpose communications tower.Apr 1, 1990 · N7034F · Destroyed NTSB NYC88LA025Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Millbrook, NYThe aircraft had just become airborne when power fluctuation occurred. On the second power loss, carburetor heat was applied but the engine lost power completely. The instructor pilot was making a turn back towards the airport when the wing contacted trees…Oct 31, 1987 · N8362G · Substantial damage NTSB NYC76FHM01Accident · No injuriesClosedCessna 150F · Red Hook, NYJul 4, 1975 · N8253S · Substantial damage NTSB NYC75FHJ27Accident · No injuriesClosedCessna 150 · Farmingdale, NYFeb 22, 1975 · N8931S · Substantial damage NTSB NYC75FFA23Accident · Minor injuriesClosedCessna 150 · Highland, NYDec 1, 1974 · N7910F · Substantial damage NTSB NYC73AN032Accident · 2 fatalClosedCessna 150F · Andes, NYAug 22, 1972 · N948MA · Destroyed NTSB NYC73AN031Accident · 1 fatalClosedCessna 150F · Smithtown, NYAug 22, 1972 · N6983F · Destroyed NTSB NYC72DFJ40Accident · No injuriesClosedCessna 150 · Spencer, NYApr 30, 1972 · N8156F · Substantial damage NTSB NYC72FFA02Accident · No injuriesClosedCessna 150 · Galway, NYJul 2, 1971 · N8830G · Substantial damage NTSB NYC71FHM24Accident · No injuriesClosedCessna 150F · Napanoch, NYApr 2, 1971 · N6718F · Destroyed NTSB NYC71DFA25Accident · No injuriesClosedCessna 150 · Voorheesville, NYNov 1, 1970 · N6239R · Substantial damage NTSB NYC71FHM07Accident · Serious injuriesClosedCessna 150F · Haverstraw, NYOct 25, 1970 · N8010S · Substantial damage NTSB NYC70DHJ08Accident · No injuriesClosedCessna 150 · Amityville, NYMay 1, 1970 · N3096X · Substantial damage NTSB NYC70FHM12Accident · Minor injuriesClosedCessna 150 · Wappingers Fls, NYApr 13, 1970 · N8094S · Destroyed NTSB NYC70DHM02Accident · No injuriesClosedCessna 150 · Spring Valley, NYJan 10, 1970 · N8049S · Substantial damage NTSB NYC70DFA02Accident · No injuriesClosedCessna 150 · Plattsburgh, NYJan 2, 1970 · N6995F · Substantial damage NTSB NYC70D0019Accident · No injuriesClosedCessna 150 · Deer Park, NYJun 13, 1969 · N3036X · Substantial damage NTSB NYC69D0473Accident · No injuriesClosedCessna 150 · Spring Valley, NYMay 31, 1969 · N8954S · Substantial damage NTSB NYC69F0339Accident · Minor injuriesClosedCessna 150F · Fire Island, NYFeb 22, 1969 · N8951S · Substantial damage NTSB NYC69F0294Accident · No injuriesClosedPiper PA-22 · Amityville, NYJan 5, 1969 · N3502A · 2 aircraft · Substantial damage NTSB NYC69F0245Accident · Minor injuriesClosedCessna 150F · Middletown, NYNov 23, 1968 · N6535F · Substantial damage NTSB NYC69D0232Accident · No injuriesClosedCessna 150 · Degrasse, NYOct 2, 1968 · N6487F · Substantial damage NTSB NYC69F0149Accident · Serious injuriesClosedCessna 150 · New City, NYSep 1, 1968 · N6592F · Destroyed NTSB NYC69D0069Accident · No injuriesClosedCessna 150 · Warwick, NYJun 29, 1968 · N6804F · Substantial damage NTSB NYC68F0461Accident · No injuriesClosedCessna 150 · Farmingdale, NYMay 6, 1968 · N6443F · Substantial damage NTSB NYC68D0472Accident · No injuriesClosedCessna 150 · White Plains, NYMar 31, 1968 · N6804F · Substantial damage NTSB NYC68D0394Accident · No injuriesClosedCessna 150 · White Plains, NYFeb 7, 1968 · N7806F · Substantial damage NTSB NYC68A0089Accident · 1 fatalClosedCessna 150F · New York, NYJan 12, 1968 · N6964F · Destroyed NTSB NYC68A0087Accident · 1 fatalClosedCessna 150 · Blauvelt, NYJan 6, 1968 · N8279F · Destroyed NTSB NYC68D0303Accident · No injuriesClosedCessna 150F · Farmingdale, NYDec 10, 1967 · N3039X · Substantial damage NTSB NYC68D0276Accident · No injuriesClosedCessna 150 · Newburgh, NYOct 20, 1967 · N7198F · Substantial damage NTSB NYC68F0218Accident · No injuriesClosedCessna 150 · Amityville, NYOct 2, 1967 · N6708F · Substantial damage NTSB NYC68D0137Accident · No injuriesClosedCessna 150 · Bloomingburgh, NYAug 19, 1967 · N6449F · Substantial damage NTSB NYC68F0097Accident · No injuriesClosedCessna 150F · Marilla, NYJul 26, 1967 · N8176F · Substantial damage NTSB NYC68F0008Accident · No injuriesClosedCessna 150 · Wappinger Fall, NYJun 3, 1967 · N8712G · Substantial damage NTSB NYC67F0697Accident · No injuriesClosedCessna 150 · E.Farmingdale, NYMay 30, 1967 · N8080S · Substantial damage NTSB NYC67D0698Accident · No injuriesClosedCessna 150 · Deer Park, NYMay 23, 1967 · N8290S · Substantial damage NTSB NYC67F0635Accident · No injuriesClosedCessna 150 · Farmingdale, NYMay 5, 1967 · N6443F · Substantial damage NTSB NYC67D0560Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYMar 26, 1967 · N8120S · Substantial damage NTSB NYC67F0557Accident · No injuriesClosedCessna 150F · Wappingers, NYMar 12, 1967 · N7910F · Substantial damage NTSB NYC67D0541Accident · No injuriesClosedCessna 150F · Farmingdale, NYMar 11, 1967 · N3012X · Substantial damage NTSB NYC67F0468Accident · No injuriesClosedCessna 150 · Deer Park, NYJan 23, 1967 · N8412G · Substantial damage NTSB NYC67D0466Accident · No injuriesClosedCessna 150 · Wallkill, NYJan 2, 1967 · N8572G · Substantial damage NTSB NYC67D0394Accident · No injuriesClosedCessna 150 · Amagansett, NYNov 18, 1966 · N8170F · Substantial damage NTSB NYC67D0231Accident · No injuriesClosedCessna 150 · Monticello, NYAug 25, 1966 · N8266F · Substantial damage NTSB NYC67F0224Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYAug 21, 1966 · N6991F · Substantial damage NTSB NYC67F0293Accident · No injuriesClosedCessna 150 · Endicott, NYJul 25, 1966 · N4308U · 2 aircraft · Substantial damage