Skip to content

NTSB investigations: Cessna 150L, NJ

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

19722026

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 ('2071826')) 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 ('2071826'))
  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 ('2071826'))
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 ERA24LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150L · Sussex, NJThe student pilot’s failure to maintain airplane control during a go-around attempt in a gusting left crosswind, resulting in an aerodynamic stall and collision with terrain.Apr 16, 2024 · N150RZ · Substantial damage NTSB ERA21LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Hardwick Township, NJThe pilot’s inadequate prefight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.Mar 30, 2021 · N6544G · Substantial damage NTSB NYC03LA134Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mount Holly, NJA loss of engine power for undetermined reasons.Jun 23, 2003 · N18146 · Substantial damage NTSB NYC96LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Matawan, NJthe student pilot's improper flare and improper recovery from a bounced landing. The gusty wind condtion was a related factor.May 25, 1996 · N10439 · Substantial damage NTSB BFO94LA080Accident · No injuriesLimited investigationFinal reportCessna 150L · Farmingdale, NJThe student pilot's improper flare and the flight instructor's inadequate supervision.Apr 30, 1994 · N1561Q · Substantial damage NTSB NYC93LA024Accident · No injuriesLimited investigationFinal reportCessna 150L · Linden, NJThe automobile driver's failure to see and avoid aircraft traffic while crossing an active runway.Oct 18, 1992 · N17023 · Substantial damage NTSB NYC93LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Princeton, NJThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway, impacting with a wall and subsequently caught fire. A contributing factor was the pilot improperly compensated for a crosswind.Oct 18, 1992 · N19402 · Substantial damage NTSB NYC90LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Tinton Falls, NJThe failure of the student pilot to ensure there was sufficient fuel on board for the planned flight. A factor related to the accident was the failure of the flight instructor to properly prepare his student for the flight.Apr 28, 1990 · N1561Q · Substantial damage NTSB NYC83LA218Accident · No injuriesLimited investigationFinal reportCessna 150L · Farmingdale, NJStudent plt was on first solo, acft operated by army flying club. During initial climb eng quit due to fuel exhaustion. Acft landed in gravel pit & flipped over.Aug 20, 1983 · N19049 · Substantial damage NTSB NYC82DA017Accident · No injuriesFinal reportCessna 150L · Caldwell, NJThe student pilot was at the controls during a landing on runway 04. The wind was from 330 degrees at 15 knots. The instructor reported that the plane was slipped to the left on short final, and shortly thereafter, the right wheel struck a snowbank. The…Jan 31, 1982 · N17065 · Substantial damage NTSB NYC81FA021Accident · 1 fatalClosedCessna 150 · Montclair, NJJan 19, 1981 · N19088 · Substantial damage NTSB NYC80FHM21Accident · No injuriesClosedCessna 150L · Caldwell, NJJul 10, 1980 · N7971G · Destroyed NTSB NYC80FHA15Accident · No injuriesClosedCessna 150 · Newton, NJJun 12, 1980 · N18016 · Substantial damage NTSB NYC80FHM15Accident · No injuriesClosedCessna 150L · Lincoln Park, NJApr 26, 1980 · N6508G · Destroyed NTSB NYC78FHM28Accident · No injuriesClosedCessna 150 · West Milford, NJSep 10, 1978 · N5459Q · 2 aircraft · Substantial damage NTSB NYC79FHD23Accident · No injuriesClosedCessna 150L · Robinsville, NJSep 2, 1978 · N19590 · Substantial damage NTSB NYC78FA047Accident · 2 fatalClosedCessna 150 · Mantoloking, NJMay 2, 1978 · N18669 · Destroyed NTSB NYC78FHM07Accident · No injuriesClosedCessna 150 · West Milford, NJFeb 26, 1978 · N1692Q · Substantial damage NTSB NYC77FHM20Accident · Minor injuriesClosedCessna 150 · Teterboro, NJJul 14, 1977 · N10979 · Substantial damage NTSB NYC77DHA20Accident · No injuriesClosedCessna 150 · Basking Ridge, NJMay 20, 1977 · N10912 · Substantial damage NTSB NYC77FHD08Accident · Minor injuriesClosedCessna 150 · Hammonton, NJFeb 23, 1977 · N6737G · Substantial damage NTSB NYC76FHM17Accident · Serious injuriesClosedCessna 150 · Fairfield, NJDec 11, 1975 · N19145 · Substantial damage NTSB NYC76FHA09Accident · No injuriesClosedCessna 150 · Blairstown, NJSep 7, 1975 · N18676 · Destroyed NTSB NYC76AN018Accident · No injuriesClosedCessna 150 · Readington, NJAug 2, 1975 · N11205 · 2 aircraft · Substantial damage NTSB NYC76AN008Accident · 2 fatalClosedCessna 150L · Florham Park, NJJul 17, 1975 · N11215 · Destroyed NTSB NYC75AN123Accident · No injuriesClosedCessna 150 · Teterboro, NJJun 22, 1975 · N10979 · 2 aircraft · Substantial damage NTSB NYC75DHA21Accident · No injuriesClosedCessna 150 · Readington, NJNov 2, 1974 · N5459Q · Substantial damage NTSB NYC75DHM01Accident · Serious injuriesClosedCessna 150 · Flanders, NJJul 7, 1974 · N5498Q · Minor damage NTSB NYC74DHA32Accident · No injuriesClosedCessna 150 · Pattenburg, NJJun 10, 1974 · N11258 · Substantial damage NTSB NYC74DHA31Accident · Minor injuriesClosedCessna 150 · Somerville, NJMay 20, 1974 · N1596Q · Substantial damage NTSB NYC74FHD34Accident · Serious injuriesClosedCessna 150L · Pennsauken, NJApr 21, 1974 · N6831G · Destroyed NTSB NYC74FHM23Accident · No injuriesClosedCessna 150 · Teterboro, NJMar 31, 1974 · N10070 · Substantial damage NTSB NYC74FHD21Accident · No injuriesClosedCessna 150L · Pitman, NJNov 13, 1973 · N6535G · Substantial damage NTSB NYC74FHA02Accident · No injuriesClosedCessna 150 · Sussex, NJJul 16, 1973 · N17065 · Substantial damage NTSB NYC73DHD36Accident · No injuriesClosedCessna 150 · Williamstown, NJApr 21, 1973 · N19344 · Substantial damage NTSB NYC73FHM22Accident · No injuriesClosedCessna 150L · Lincoln Park, NJMar 1, 1973 · N18562 · Substantial damage NTSB NYC73FHD26Accident · No injuriesClosedCessna 150L · Williamstown, NJFeb 14, 1973 · N18210 · Substantial damage NTSB NYC73DHD15Accident · No injuriesClosedCessna 150 · Hammaton, NJNov 11, 1972 · N1625Q · Substantial damage NTSB NYC73FHD03Accident · No injuriesClosedCessna 150L · Ocean City, NJJul 23, 1972 · N6546G · Substantial damage