Skip to content

NTSB investigations: Cessna 150F, IA

25 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" = '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 ('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\" = '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 ('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" = '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 ('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 GAA19CA363Accident · No injuriesData collectionFinal reportCessna 150 · Elkader, IAThe pilot's delayed decision to go around, which resulted in a collision with trees and terrain.Jun 20, 2019 · N6471F · Substantial damage NTSB CEN13CA087Accident · No injuriesData collectionFinal reportCessna 150F · Red Oak, IAThe loss of control while landing due to the solo student pilot's delay to execute a go-around and his improper control inputs during a bounced landing.Nov 20, 2012 · N8000S · Substantial damage NTSB CEN11LA366Accident · No injuriesLimited investigationFinal reportCessna 150F · Sully, IAThe pilot's failure to attain an adequate climb rate during the initial takeoff, resulting in the airplane settling back down and departing the runway. Contributing to the accident was the pilot's inadequate preflight planning and preparation.May 31, 2011 · N7818F · Substantial damage NTSB CHI90LA257Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Clutier, IAThe pilot's failure to compensate for wind conditions.Sep 6, 1990 · N3016X · Substantial damage NTSB MKC83LA075Accident · No injuriesLimited investigationFinal reportCessna 150F · Ollie, IAThe student reported that the eng lost aprx 500 RPM while he was practicing turns & stalls at an altitude of aprx 3500 ft MSL. Reportedly, the situation became worse & he was unable to maintain altitude. He applied carburetor heat, but it did not help.…Mar 7, 1983 · N8803G · Substantial damage NTSB MKC82FCD05CaseClosedCessna 150F · Keosauqua, IADec 23, 1981 · N3510L NTSB MKC79FA043Accident · 1 fatalClosedCessna 150F · Independence, IAJul 26, 1979 · N6879F · Destroyed NTSB MKC77DCD11Accident · No injuriesClosedCessna 150 · Oxford, IAFeb 10, 1977 · N7996F · Substantial damage NTSB MKC75FCD30Accident · No injuriesClosedCessna 150 · Ottuma, IADec 31, 1974 · N7757F · Substantial damage NTSB MKC71DCD94Accident · No injuriesClosedCessna 150 · Ankeny, IAJun 30, 1971 · N6999F · Substantial damage NTSB MKC71FCD33Accident · Serious injuriesClosedCessna 150 · Oasis, IANov 24, 1970 · N7835F · Substantial damage NTSB MKC71DCD14Accident · Minor injuriesClosedCessna 150F · Lenox, IAAug 6, 1970 · N8206F · Substantial damage NTSB MKC70DCD19Accident · No injuriesClosedCessna 150 · Jefferson, IAFeb 21, 1970 · N6999F · Substantial damage NTSB MKC70D0173Accident · Minor injuriesClosedCessna 150 · Council Blfs, IAAug 31, 1969 · N8547G · Substantial damage NTSB MKC70D0105Accident · No injuriesClosedCessna 150 · Davenport, IAAug 6, 1969 · N8613S · Substantial damage NTSB MKC70D0044Accident · No injuriesClosedCessna 150 · Woodbine, IAJun 15, 1969 · N8807S · Substantial damage NTSB MKC69D0177Accident · No injuriesClosedCessna 150 · Davenport, IASep 12, 1968 · N8613S · Substantial damage NTSB MKC68D0328Accident · No injuriesClosedCessna 150 · Washington, IANov 17, 1967 · N7799F · Substantial damage NTSB MKC68D0079Accident · No injuriesClosedCessna 150 · Cedar Rapids, IAJul 12, 1967 · N8802S · Substantial damage NTSB MKC68D0047Accident · No injuriesClosedCessna 150 · Red Oak, IAJun 19, 1967 · N8106S · Substantial damage NTSB MKC67D0531Accident · No injuriesClosedCessna 150F · Sioux City, IAApr 2, 1967 · N8093F · Substantial damage NTSB MKC67D0334Accident · No injuriesClosedCessna 150F · Jefferson, IANov 19, 1966 · N7996F · Substantial damage NTSB MKC67D0164Accident · No injuriesClosedCessna 150F · Boone, IAAug 23, 1966 · N6999F · Substantial damage NTSB MKC67D0121Accident · No injuriesClosedCessna 150 · Red Oak, IAJul 18, 1966 · N8106S · Substantial damage NTSB MKC66D0541Accident · No injuriesClosedCessna 150 · Atlantic, IAApr 18, 1966 · N8807S · Substantial damage