NTSB investigations: Cessna 150H, NJ

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

19682026

NTSB investigations: Cessna 150H, NJ per year, 1968–2026: 16 cases
1968	1
1969	1
1970	3
1971	4
1972	2
1975	1
1981	1
1982	1
1996	1
2009	1

Where

Open the map

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 ('2071818')) 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 ('2071818'))
  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 ('2071818'))
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 ERA09LA459Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Sussex, NJThe pilot’s improper pre-flight planning and take off over gross weight limits.Aug 12, 2009 · N6676S · Substantial damage NTSB NYC96LA066Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Linden, NJthe pilot's inadequate preflight and failure to follow the checklist to ensure that the fuel selector valve was in the ON position, which resulted in fuel starvation and subsequent loss of engine power. In addition, the pilot failed to maintain airspeed…Feb 26, 1996 · N6964S · Substantial damage NTSB NYC82DA113Accident · No injuriesFinal reportCessna 150H · Cross Keys, NJAccording to the pilot, the aircraft touched down during landing, about halfway down the runway, then bounced several times. He elected to go around, applied full power, and moved the flap handle to the up position. The flaps were fully extended and did not…May 31, 1982 · N972MA · Substantial damage NTSB NYC82FHD02Accident · Minor injuriesClosedCessna 150H · Manahawkin, NJOct 19, 1981 · N23402 · Destroyed NTSB NYC76FHM14Accident · Minor injuriesClosedCessna 150H · Lincoln Park, NJOct 23, 1975 · N6443S · Substantial damage NTSB NYC73FHM17Accident · Minor injuriesClosedCessna 150H · Newfoundland, NJNov 19, 1972 · N50271 · Substantial damage NTSB NYC72FHM42Accident · Minor injuriesClosedCessna 150H · Fort Lee, NJApr 16, 1972 · N7009S · Substantial damage NTSB NYC72DHM15Accident · No injuriesClosedCessna 150 · Teterboro, NJNov 21, 1971 · N23072 · Substantial damage NTSB NYC72FHM14Accident · No injuriesClosedCessna 150H · East Hanover, NJOct 27, 1971 · N6586S · Substantial damage NTSB NYC71FHD52Accident · Serious injuriesClosedCessna 150 · Evesham, NJJun 4, 1971 · N7067S · Destroyed NTSB NYC71FHA31Accident · No injuriesClosedCessna 150 · Milford, NJFeb 6, 1971 · N23405 · Substantial damage NTSB NYC71AN055Accident · 1 fatalClosedCessna 150H · Mountain Lakes, NJNov 7, 1970 · N6676S · Substantial damage NTSB NYC70DHD28Accident · No injuriesClosedCessna 150 · Medford, NJMay 23, 1970 · N6417S · Substantial damage NTSB NYC70DHA08Accident · No injuriesClosedCessna 150 · Somerville, NJMar 19, 1970 · N50248 · 2 aircraft · Substantial damage NTSB NYC69D0370Accident · No injuriesClosedCessna 150 · Whitehouse, NJMar 17, 1969 · N22439 · Substantial damage NTSB NYC69A0042Accident · 1 fatalClosedCessna 150 · Clementon, NJSep 28, 1968 · N7071S · Destroyed