Skip to content

NTSB investigations: Cessna 150F, MO

61 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

19652026

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 ('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\" = '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 ('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" = '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 ('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 WPR18LA255Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Richland, MOA loss of directional control during a touch-and-go landing in gusting crosswind conditions.Sep 4, 2018 · N8028F · Substantial damage NTSB CHI07LA097Accident · No injuriesLimited investigationFinal reportCessna 150F · Grain Valley, MOThe pilot's failure to assure an adequate fuel supply which resulted in fuel exhaustion. Factors associated with the accident were the street sign which was contacted, the pilot's inability to maintain directional control of the airplane and the ditch which…Apr 5, 2007 · N7893F · Substantial damage NTSB CHI93LA213Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Birch Tree, MOThe pilot's failure to maintain aircraft control.Jun 18, 1993 · N8476G · Substantial damage NTSB CHI92LA146Accident · No injuriesLimited investigationFinal reportCessna 150F · Eldon, MOA binding exhaust valve resulting in a partial loss of engine power. Factors in the accident are rising terrain conditions, inadequate aircraft climb capability, and a ditch in the forced landing area.May 8, 1992 · N8081S · Substantial damage NTSB MKC89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Monroe City, MOFuel contamination and the pilot's failure to comply with a maintenance AD. Contributing to the accident was the pilot's operation of the airplane with a known deficiency.Mar 11, 1989 · N8079S · Substantial damage NTSB MKC88FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Mansfield, MOA witness saw the acft flying at low alt as it passed in front of her car at dusk in a northeasterly drctn. She rprtd the acft contd down a valley toward power lines that spanned an open field. She saw the acft pull up rapidly, become entangled in the power…May 9, 1988 · N8605S · Substantial damage NTSB MKC87LA068Accident · No injuriesLimited investigationFinal reportCessna 150F · Fremont, MOThe student pilot got off course on the first leg of his solo cross-country flight. He landed at an airport for fuel and directions, but the airport was deserted. When he departed for a nearby airport, he could not find that airport. After the student pilot…Mar 28, 1987 · N6978F · Substantial damage NTSB MKC86FA080Accident · Serious injuriesField investigationFinal reportCessna 150F · Hannibal, MOThe student plt was attempting to land with a right crosswind component in excess of 15 knots. He used a crab angle on final but as the acft apch the rwy he applied rudder. He said, with full rudder the acft was still not aligned with the rwy and he decided…Apr 5, 1986 · N8917S · Substantial damage NTSB MKC85FA069Accident · 1 fatalField investigationFinal reportCessna 150F · Waldron, MOWhile maneuvering northbound on the Missouri river levee the passenger noticed the plt flying just above the levee road. The passenger stated the plt told him they were forty feet off the ground but sometimes lower. The passenger stated he saw the pickup…Mar 9, 1985 · N8078F · Destroyed NTSB MKC82FCG16Accident · Minor injuriesClosedCessna 150F · Independence, MODec 31, 1981 · N8287F · Substantial damage NTSB MKC81DCG10Accident · Minor injuriesClosedCessna 150 · Webb City, MONov 11, 1980 · N8290F · Substantial damage NTSB MKC79FA057Accident · 1 fatalClosedCessna 150F · West Quincy, MOSep 20, 1979 · N8240S · Substantial damage NTSB MKC78FCA07Accident · Minor injuriesClosedCessna 150F · St.Louis, MONov 21, 1977 · N8613G · Substantial damage NTSB MKC75FCA17Accident · No injuriesClosedCessna 150F · Morley, MODec 13, 1974 · N8621G · Substantial damage NTSB MKC74DCA13Accident · No injuriesClosedCessna 150F · Matthews, MOOct 25, 1973 · N6887F · Substantial damage NTSB MKC73DCG15Accident · No injuriesClosedCessna 150 · Lees Summit, MOSep 30, 1972 · N8050S · Substantial damage NTSB MKC71DCG69Accident · Minor injuriesClosedCessna 150 · Kirksville, MOMay 16, 1971 · N6839F · Destroyed NTSB MKC71DCG53Accident · Minor injuriesClosedCessna 150 · Pt Lookout, MOApr 8, 1971 · N7702F · Substantial damage NTSB MKC71AK020Accident · 2 fatalClosedCessna 150F · Forsyth, MOOct 18, 1970 · N8254F · Destroyed NTSB MKC70DCG37Accident · No injuriesClosedCessna 150 · Carrolton, MOJun 26, 1970 · N6777F · Substantial damage NTSB MKC70D0166Accident · No injuriesClosedCessna 150 · Maysville, MOAug 2, 1969 · N6519F · Substantial damage NTSB MKC70F0116Accident · No injuriesClosedCessna 150 · Albany, MOJul 25, 1969 · N8955S · Substantial damage NTSB MKC70D0073Accident · No injuriesClosedCessna 150F · Luray, MOJul 4, 1969 · N8101F · Substantial damage NTSB MKC70D0061Accident · No injuriesClosedCessna 150F · Lebanon, MOJun 19, 1969 · N8768G · Substantial damage NTSB MKC69D0381Accident · No injuriesClosedCessna 150 · Odessa, MOMar 30, 1969 · N6451F · Substantial damage NTSB MKC69D0407Accident · No injuriesClosedCessna 150 · Kansas City, MOMar 1, 1969 · N8300G · Substantial damage NTSB MKC69D0211Accident · No injuriesClosedCessna 150 · Columbia, MOAug 20, 1968 · N8500G · Substantial damage NTSB MKC69D0186Accident · No injuriesClosedCessna 150 · Springfield, MOJun 19, 1968 · N8254F · Substantial damage NTSB MKC69D0038Accident · No injuriesClosedCessna 150F · Joplin, MOMay 18, 1968 · N6417F · Substantial damage NTSB MKC68A0065Accident · 1 fatalClosedStinson V-77 · Springfield, MOMay 8, 1968 · N69440 · 2 aircraft · Substantial damage NTSB MKC68D0599Accident · No injuriesClosedCessna 150 · Lincoln, MOApr 28, 1968 · N7081F · Substantial damage NTSB MKC68D0595Accident · No injuriesClosedCessna 150 · Springfield, MOApr 17, 1968 · N7828F · Substantial damage NTSB MKC68D0530Accident · No injuriesClosedCessna 150F · Clinton, MOApr 15, 1968 · N8013S · Substantial damage NTSB DCA68A0004Accident · 2 fatalClosedDouglas DC-9 · St Louis, MOMar 27, 1968 · N970Z · 2 aircraft · Substantial damage NTSB MKC68D0424Accident · No injuriesClosedCessna 150F · Ferrelview, MODec 3, 1967 · N6684F · Substantial damage NTSB MKC68D0460Accident · No injuriesClosedCessna 150 · Springfield, MONov 13, 1967 · N7702F · Substantial damage NTSB MKC68A0014Accident · 2 fatalClosedCessna 150 · Jefferson City, MOAug 25, 1967 · N563Q · Destroyed NTSB MKC68D0220Accident · Minor injuriesClosedCessna 150 · Neosho, MOAug 5, 1967 · N8740S · Destroyed NTSB MKC68F0318Accident · No injuriesClosedCessna 150 · Ft Leonrd Wood, MOJul 22, 1967 · N8835S · Substantial damage NTSB MKC68D0131Accident · No injuriesClosedCessna 150 · St.Charles, MOJul 22, 1967 · N8666S · Substantial damage NTSB MKC68D0117Accident · No injuriesClosedCessna 150 · Republic, MOJul 10, 1967 · N3060X · Substantial damage NTSB MKC68F0036Accident · No injuriesClosedCessna 150F · St Clair, MOJun 30, 1967 · N6777F · Substantial damage NTSB MKC68F0293Accident · No injuriesClosedCessna 150 · St Louis, MOJun 20, 1967 · N3031X · Substantial damage NTSB MKC68F0254Accident · No injuriesClosedCessna 150 · Taylor, MOMay 24, 1967 · N6519F · Substantial damage NTSB MKC67D0574Accident · No injuriesClosedCessna 150 · Fortescue, MOMay 4, 1967 · N8050S · Substantial damage NTSB MKC67D0546Accident · No injuriesClosedCessna 150 · Helena, MOMar 23, 1967 · N6451F · Substantial damage NTSB MKC67D0440Accident · No injuriesClosedCessna 150 · St. Charles, MOFeb 6, 1967 · N8558G · Substantial damage NTSB MKC67F0351Accident · No injuriesClosedCessna 150 · Columbia, MODec 17, 1966 · N3131X · Substantial damage NTSB MKC67A0035Accident · 1 fatalClosedCessna 150 · Creve Coeur, MONov 20, 1966 · N6791F · Destroyed NTSB MKC67D0326Accident · No injuriesClosedCessna 150 · Branson, MOOct 31, 1966 · N7702F · Substantial damage