Skip to content

NTSB investigations: Cessna 150H, MO

29 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

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" = 'MO' 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\" = 'MO' 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" = 'MO' 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 CEN18FA384Accident · 2 fatalField investigationFinal reportCessna 150 · Festus, MOA total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…Sep 21, 2018 · N7152S · Substantial damage NTSB CHI04CA239Accident · No injuriesData collectionFinal reportCessna 150H · Golden, MOThe pilot's misjudgment of speed and distance. A factor was the tires positioned at the end of the runway.Aug 22, 2004 · N23316 · Substantial damage NTSB CHI01LA147Accident · 1 fatalLimited investigationFinal reportCessna 150H · Protem, MOThe overload of the flap control cable for undetermined reasons resulting in aircraft control not being possible. The trees were a factor.May 27, 2001 · N23033 · Destroyed NTSB CHI94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kansas City, MOLoss of power for an undetermined reason, and the pilot initiating the flight with a rough running engine. Factors related to the accident were: the building and the lack of suitable terrain for a forced landing.Oct 22, 1993 · N23487 · Destroyed NTSB MKC90LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hornersville, MOPoor judgement of the pilot due to consumption of alcohol, and his misjudgement of distance and altitude to the runway, while on final approach, which subsequently resulted in a touchdown and nose over short of the runway.Jan 12, 1990 · N22182 · Substantial damage NTSB MKC87LA111Accident · No injuriesLimited investigationFinal reportCessna 150H · Miami, MOThe pilot had completed the landing at a private airport and was taxiing at the edge of the gravel runway. He hit a clump of grass and dirt and partially collapsed the nose gear.May 11, 1987 · N6561S · Substantial damage NTSB MKC87LA003Accident · No injuriesLimited investigationFinal reportCessna 150J · Peculiar, MOThe plt reported that the acft encountered a downdraft as he made his apch to land at his pvt strip. The wind was from 250 degs at 7 KTS, a headwind for the landing acft. The plt reported no mechanical control difficulty during final apch. The plt reported…Oct 5, 1986 · N6578S · Substantial damage NTSB MKC84FA179Accident · 1 fatalField investigationFinal reportCessna 150H · Golden, MOThe acft was flying low over trees when it banked steeply and spun to the ground according to a witness. The acft impacted the ground in an almost vertical nose down descent. The plt was a student who was on a local solo flt. No mechanical or physical…Jun 19, 1984 · N23233 · Destroyed NTSB MKC84FA146Accident · 2 fatalField investigationFinal reportCessna 150H · Camdenton, MOWitnesses observed the acft flying low over a lake. As it approach the home of the plt's parents, the acft's wings moved as though waving, then the acft entered a steep climb. After reaching its maximum height from the pull-up, the acft rolled into a steep…May 25, 1984 · N7192S · Destroyed NTSB MKC83LA123Accident · No injuriesLimited investigationFinal reportCessna 150H · Salem, MOThe flt instructor (CFI) initiated a simulated forced landing at about 500 ft AGL as the acft was climbing during takeoff at night. The student elected to turn downwind for a landing on the departure rwy. When the CFI determined that the student would not be…Jun 10, 1983 · N6732S · Substantial damage NTSB MKC78FA049Accident · 1 fatalClosedCessna 150H · St Louis, MOJun 19, 1978 · N50374 · Destroyed NTSB MKC77DCG33Accident · No injuriesClosedCessna 150 · Kansas City, MOJul 5, 1977 · N7038S · Substantial damage NTSB MKC76FCG09Accident · No injuriesClosedCessna 150 · Kansas City, MOJul 25, 1975 · N22070 · Substantial damage NTSB MKC73DCG51Accident · No injuriesClosedCessna 150 · Strafford, MOJun 9, 1973 · N23449 · Substantial damage NTSB MKC73DCA04Accident · No injuriesClosedCessna 150H · Creve Coeur, MOAug 28, 1972 · N50158 · Substantial damage NTSB MKC72DCG03Accident · No injuriesClosedCessna 150 · Grain Valley, MOJun 29, 1971 · N7253S · Substantial damage NTSB MKC71AK052Accident · 1 fatalClosedCessna 150H · Lees Summit, MOApr 24, 1971 · N6773S · Destroyed NTSB MKC71DCA30Accident · No injuriesClosedCessna 150 · West Plains, MOApr 11, 1971 · N22542 · Substantial damage NTSB MKC71FCG48Accident · Serious injuriesClosedCessna 150 · Beverly, MOMar 12, 1971 · N6702S · Destroyed NTSB MKC71DCG45Accident · Minor injuriesClosedCessna 150H · Shell City, MOFeb 27, 1971 · N6762S · Substantial damage NTSB MKC71DCA17Accident · No injuriesClosedCessna 150H · Poplar Bluff, MOOct 28, 1970 · N22599 · Substantial damage NTSB MKC71FCA11Accident · Serious injuriesClosedCessna 150H · Van Buren, MOAug 16, 1970 · N22124 · Substantial damage NTSB MKC70FCG17Accident · No injuriesClosedCessna 150H · Clinton, MOFeb 21, 1970 · N6742S · Substantial damage NTSB MKC70D0317Accident · No injuriesClosedCessna 150H · Edgerton, MONov 22, 1969 · N6962S · Substantial damage NTSB MKC70F0207Accident · No injuriesClosedCessna 150H · Ft Leonard Wd, MOAug 30, 1969 · N22062 · Substantial damage NTSB MKC70D0075Accident · No injuriesClosedCessna 150H · California, MOJul 1, 1969 · N50317 · Substantial damage NTSB MKC69D0304Accident · No injuriesClosedCessna 150H · Hinton, MONov 13, 1968 · N22113 · Substantial damage NTSB MKC69A0010Accident · 2 fatalClosedCessna 150H · Republic, MOAug 9, 1968 · N7115S · Destroyed NTSB MKC69D0064Accident · No injuriesClosedCessna 150 · Carrollton, MOJun 16, 1968 · N22533 · Substantial damage