Skip to content

NTSB investigations: Cessna 150F, NJ

24 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" = 'NJ' 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\" = 'NJ' 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" = 'NJ' 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 ERA22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150F · Pittstown, NJThe partial loss of engine power due to a stuck exhaust valve.Jul 13, 2022 · N8761G · Substantial damage NTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Sep 12, 2015 · N8185F · Destroyed NTSB NYC92FA185Accident · 1 fatalField investigationFinal reportCessna 150F · Lake Neepaulin, NJAn inflight collision with trees after the pilot failed to outclimb the terrain. Factors related to the accident were the pilot's improper use of the flaps and the pilot's decision to operate the airplane over the maximum allowable gross weight.Sep 13, 1992 · N8725G · Substantial damage NTSB NYC80FHD23Accident · No injuriesClosedCessna 150 · Little Egg Hbr, NJAug 10, 1980 · N7781F · Substantial damage NTSB NYC78FHM20Accident · Serious injuriesClosedCessna 182 · Fairfield, NJJul 9, 1978 · N1287S · 2 aircraft · Substantial damage NTSB NYC78FHM03Accident · No injuriesClosedCessna 150F · Teterboro, NJJan 18, 1978 · N8266F · Substantial damage NTSB NYC76FHA23Accident · No injuriesClosedCessna 150 · Reading, NJMar 20, 1976 · N8086F · Destroyed NTSB NYC74FHM31Accident · Serious injuriesClosedCessna 150 · Colts Neck, NJMay 25, 1974 · N3127X · Substantial damage NTSB NYC71DHD05Accident · No injuriesClosedCessna 150 · Moorestown, NJJul 8, 1970 · N7024F · Substantial damage NTSB NYC69F0048Accident · No injuriesClosedCessna 150F · Medford, NJJul 17, 1968 · N6486F · Substantial damage NTSB NYC69F0050Accident · Serious injuriesClosedCessna 150F · Ringwood, NJJul 12, 1968 · N7951F · Substantial damage NTSB NYC69D0013Accident · Minor injuriesClosedCessna 150F · Lumberton, NJJun 6, 1968 · N8367G · Substantial damage NTSB NYC68D0451Accident · No injuriesClosedCessna 150 · Medford, NJApr 20, 1968 · N8901S · Substantial damage NTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJOct 29, 1967 · N8398J · 2 aircraft · Substantial damage NTSB NYC68F0233Accident · No injuriesClosedCessna 150 · Totowa, NJOct 11, 1967 · N6884F · Destroyed NTSB NYC67D0614Accident · No injuriesClosedCessna 150 · Totowa, NJMar 25, 1967 · N8947S · Substantial damage NTSB NYC67F0552Accident · No injuriesClosedCessna 150 · Teterboro, NJMar 19, 1967 · N7929F · Substantial damage NTSB NYC67F0504Accident · No injuriesClosedCessna 150 · Whitehouse, NJFeb 12, 1967 · N6559F · Substantial damage NTSB NYC67F0448Accident · No injuriesClosedCessna 150 · Berlin, NJJan 2, 1967 · N7951F · Substantial damage NTSB NYC67D0447Accident · No injuriesClosedCessna 150 · West Caldwell, NJDec 16, 1966 · N8224F · Substantial damage NTSB NYC67D0399Accident · No injuriesClosedCessna 150 · Lincoln Park, NJNov 22, 1966 · N8990S · Substantial damage NTSB NYC67D0312Accident · No injuriesClosedCessna 150 · Franklin, NJOct 15, 1966 · N8122F · Substantial damage NTSB NYC66A0138Accident · 1 fatalClosedCessna 150F · Fairfield, NJMay 31, 1966 · N8782S · Destroyed NTSB NYC66D0572Accident · No injuriesClosedCessna 150 · Totowa, NJFeb 27, 1966 · N8160S · Substantial damage