Skip to content

NTSB investigations: Cessna 150G, IA

21 cases on aircraft the registry lists as Cessna 150G. 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" = 'IA' 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 ('2071816')) 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\" = 'IA' 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 ('2071816'))
  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" = 'IA' 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 ('2071816'))
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 CEN23LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Pocahantas, IAThe pilot’s landing flare which resulted in a bounced landing and the nose landing gear collapsing. Contributing to the accident was the airplane's encounter with adverse weather conditions which led to structural icing that affected flight characteristics…Dec 20, 2022 · N2930J · Substantial damage NTSB MKC90LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Ankeny, IAFuel contamination and inadequate aircraft preflight by the pilot in command.Mar 26, 1990 · N2254J · Substantial damage NTSB MKC87LA112Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest City, IAAfter reaching a cruise alt of 1000 ft AGL, the plt noticed a lack of oil pressure. He elected to make a precautionary landing in an unplowed soft field. The plt then reduced pwr to idle and set up for the landing. During the landing roll the acft nosed over.…May 19, 1987 · N3767J · Substantial damage NTSB MKC83FA215Accident · Serious injuriesField investigationFinal reportCessna 150G · Perry, IAThe plt was participating in a spot landing contest. A witness near the apch end of the rwy reported that when the acft was on final apch, it suddenly settled below tall trees about 1/8 mi from the rwy. He reported that it then went into a right bank, nose up…Sep 9, 1983 · N2452J · Substantial damage NTSB MKC79DCD08Accident · No injuriesClosedCessna 150G · Burlington, IAJan 7, 1979 · N2431J · Substantial damage NTSB MKC76FCD27Accident · Minor injuriesClosedCessna 150 · Davenport, IAFeb 17, 1976 · N3448J · Destroyed NTSB MKC72DCD71Accident · No injuriesClosedCessna 150G · Marion, IAMay 11, 1972 · N2979J · Substantial damage NTSB MKC72DCD30Accident · No injuriesClosedCessna 150G · Knoxville, IAAug 25, 1971 · N3012S · Substantial damage NTSB MKC72DCD27Accident · No injuriesClosedCessna 150G · Calamus, IAAug 21, 1971 · N4738X · Substantial damage NTSB MKC71DCD80Accident · No injuriesClosedCessna 150G · Grundy Ctr, IAMay 5, 1971 · N3993J · Substantial damage NTSB MKC71DCD61Accident · No injuriesClosedCessna 150G · Des Moines, IAFeb 11, 1971 · N3903J · Substantial damage NTSB MKC70DCD39Accident · No injuriesClosedCessna 150G · Maxwell, IAMay 28, 1970 · N3012S · Substantial damage NTSB MKC70DGD40Accident · No injuriesClosedCessna 150A · Maysville, IAApr 26, 1970 · N4738X · Substantial damage NTSB MKC70DCD14Accident · No injuriesClosedCessna 150G · Oskaloosa, IAFeb 3, 1970 · N3050S · Substantial damage NTSB MKC70DCD16Accident · No injuriesClosedCessna 150A · Missouri Vly, IAFeb 1, 1970 · N2809S · Substantial damage NTSB MKC70D0236Accident · Minor injuriesClosedCessna 150 · Council Bluf, IASep 21, 1969 · N2846S · Substantial damage NTSB MKC69D0239Accident · No injuriesClosedCessna 150G · Council Blfs, IAOct 13, 1968 · N2809S · Substantial damage NTSB MKC68D0555Accident · Minor injuriesClosedCessna 150 · St.Paul, IAMay 5, 1968 · N4030J · Substantial damage NTSB MKC68D0439Accident · Minor injuriesClosedCessna 150G · Dubuque, IAJan 30, 1968 · N3954J · Substantial damage NTSB MKC68D0277Accident · No injuriesClosedCessna 150 · Hamburg, IANov 6, 1967 · N3128J · Substantial damage NTSB MKC67D0370Accident · No injuriesClosedCessna 150F · Alta Vista, IADec 24, 1966 · N2431J · Substantial damage