Skip to content

NTSB investigations: Cessna 150J, IL

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

19692026

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" = 'IL' 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 ('2071820')) 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\" = 'IL' 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 ('2071820'))
  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" = 'IL' 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 ('2071820'))
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 CHI08CA276Accident · Minor injuriesData collectionFinal reportCessna 150J · Spring Grove, ILThe pilot's inadequate preflight planning and his failure to maintain clearance from the trees. Contributing factors were the trees and the high density altitude.Aug 31, 2008 · N50753 · Substantial damage NTSB CHI89LA163Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Putnam, ILImproper use of carburetor heat by the pilot which resulted in reduced power for takeoff. The obstructions (hangar & trees) and weather conditions were contributing factors.Aug 4, 1989 · N60263 · Substantial damage NTSB CHI88LA006Accident · No injuriesLimited investigationFinal reportCessna 150J · Springfield, ILWhile taxiing back to the parking ramp, after a short instructional flight, the student and flight instructor were looking ahead into the parking area for a vacant parking place. While they were searching for a place to park, the right wing of the aircraft…Oct 19, 1987 · N60481 · Substantial damage NTSB CHI82DA344Accident · No injuriesFinal reportCessna 150J · Dekalb, ILThe student pilot was practicing touch-and-go landings. He stated that on about his sixth landing, he touched down hard on the main gear then lowered the nose. As the nose wheel touched down, the aircraft veered to the left and the right wing contacted the…Jul 29, 1982 · N60028 · Substantial damage NTSB CHI82DA249Accident · No injuriesFinal reportCessna 150J · Alton, ILThe student and instructor pilot (ip) were departing on an instructional flight. Immediately after takeoff, the ip retarded the throttle to simulate an engine failure. The student lowered the nose to maintain airspeed, then prematurely raised it again. The ip…Jul 9, 1982 · N61130 · Substantial damage NTSB CHI80FA069Accident · 1 fatalClosedCessna 150J · Akin, ILSep 22, 1980 · N60771 · Destroyed NTSB CHI78FEE21Accident · No injuriesClosedCessna 150J · Wedron, ILFeb 12, 1978 · N60731 · Substantial damage NTSB CHI77DEE54Accident · No injuriesClosedCessna 150J · Tonica, ILSep 22, 1977 · N50648 · Substantial damage NTSB CHI76FEE72Accident · No injuriesClosedCessna 150J · Hinckley, ILAug 20, 1976 · N50997 · Substantial damage NTSB CHI76FEE55Accident · Serious injuriesClosedCessna 150J · Plainfield, ILApr 22, 1976 · N61237 · Destroyed NTSB CHI74DEV07Accident · No injuriesClosedCessna 150 · Peoria, ILJul 31, 1973 · N61198 · Substantial damage NTSB CHI73DEV25Accident · No injuriesClosedCessna 150 · Peoria, ILApr 22, 1973 · N60778 · Substantial damage NTSB CHI73FEE38Accident · No injuriesClosedCessna 150J · West Chicago, ILDec 28, 1972 · N106DP · Substantial damage NTSB CHI72AC074Accident · 2 fatalClosedCessna 150J · Quincy, ILMar 18, 1972 · N51092 · Destroyed NTSB CHI72FEE19Accident · No injuriesClosedCessna 150J · Grayslake, ILAug 14, 1971 · N61349 · Minor damage NTSB CHI71DBD28Accident · Minor injuriesClosedCessna 150 · Moline, ILSep 25, 1970 · N50551 · Substantial damage NTSB CHI70AC064Accident · 2 fatalClosedCessna 150J · Brighton, ILMar 21, 1970 · N61034 · Destroyed NTSB CHI70D0375Accident · No injuriesClosedCessna 150 · Ottawa, ILDec 27, 1969 · N60087 · Substantial damage NTSB CHI70F0207Accident · No injuriesClosedCessna 150 · Wheeling, ILAug 15, 1969 · N50973 · Substantial damage NTSB CHI69F0563Accident · No injuriesClosedCessna 150 · Rockford, ILApr 5, 1969 · N50850 · Substantial damage