Skip to content

NTSB investigations: Cessna 150F, CO

47 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" = 'CO' 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\" = 'CO' 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" = 'CO' 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 DEN01LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Meeker, COFuel exhaustion due to the failure of the instructor to ensure there was sufficient fuel for the flight. Factors were the instructor's inadequate supervision of the student pilot, and the deep snow-covered terrain.Jan 8, 2001 · N8067F · Substantial damage NTSB FTW95LA389Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Salida, COFailure by the pilot to adequately plan the flight and the aircraft altitude capability. Factors are: high altitude, high density altitude, inadequate training in mountain flying, and lack of familiarity with the geographic area.Sep 11, 1995 · N8554G · Substantial damage NTSB FTW95LA276Accident · No injuriesLimited investigationFinal reportCessna 150F · Garfield, COThe pilot's delayed decision to deviate away from the deteriorating weather. Factors were his inadequate evaluation of the weather, high density altitude, and the resultant inadvertent operation of the airplane beyond the climb performance limitations of the…Jun 30, 1995 · N8155S · Substantial damage NTSB DEN88LA198Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Peyton, COSep 3, 1988 · N6737F · Substantial damage NTSB DEN87LA123Accident · No injuriesLimited investigationFinal reportCessna 150 · Akron, COThe student plt had just purchased N8649G and had decided to fly it. He had not been endorsed for solo flt. After a successful takeoff and a short cross-country flt, he returned to the Akron aprt for landing. During the attempted landing, control of the acft…May 12, 1987 · N8649G · Substantial damage NTSB DEN85FA069Accident · 2 fatalField investigationFinal reportCessna 150F · Marvel, COA witness reported seeing the acft enter a dive and level off aprx 10-15 ft AGL. The acft continued flt close to the ground for aprx 1/2 mile, the witness stated, before a near vertical climb was entered until the acft stalled. Recovery from the stall was not…Jan 26, 1985 · N6787F · Substantial damage NTSB DEN82DA151Accident · No injuriesFinal reportCessna 150F · Sheridan Lake, COThe pilot reported that he was on a flight to check his fields and crops for possible hail damage. Reportedly, he decided to see how a friend was doing with his wheat harvest and to see if he had received hail damage. The pilot stated that he spotted his…Jul 19, 1982 · N8232S · Substantial damage NTSB DEN81FTE42Accident · No injuriesClosedCessna 150 · La Junta, COMay 31, 1981 · N8713S · Substantial damage NTSB DEN79FTE32Accident · Minor injuriesClosedCessna 150 · Boulder, COApr 23, 1979 · N6794F · Substantial damage NTSB DEN76FTE42Accident · No injuriesClosedDavenport BD-2 · Broomfield, COFeb 14, 1976 · N5131 · 2 aircraft · Substantial damage NTSB DEN75FTE33Accident · Serious injuriesClosedCessna 150F · Durango, COOct 28, 1974 · N6435F · Destroyed NTSB DEN74DTE48Accident · No injuriesClosedCessna 172 · Ft Collins, COJan 30, 1974 · N7959F · Substantial damage NTSB DEN74FTE20Accident · Serious injuriesClosedCessna 150F · Denver, COSep 15, 1973 · N8114F · Substantial damage NTSB DEN73FTE95Accident · No injuriesClosedCessna 150 · Broomfield, COJun 23, 1973 · N8696G · Destroyed NTSB DEN73FTE05Accident · No injuriesClosedCessna 150F · Aurora, COJul 12, 1972 · N7839F · Substantial damage NTSB DEN72FTE74Accident · No injuriesClosedCessna 150F · Montrose, COMay 31, 1972 · N6440F · Substantial damage NTSB DEN72FTE49Accident · No injuriesClosedCessna 150 · Littleton, CODec 15, 1971 · N6812F · Substantial damage NTSB DEN71FTE01Accident · No injuriesClosedCessna 150 · Broomfield, COMay 18, 1971 · N8294S · Substantial damage NTSB DEN71FXD32Accident · Serious injuriesClosedCessna 150F · Watkins, COOct 17, 1970 · N8056F · Substantial damage NTSB DEN70DXD30Accident · No injuriesClosedCessna 150F · Aurora, COApr 21, 1970 · N8344G · Substantial damage NTSB DEN70A0021Accident · 2 fatalClosedCessna 150F · Aurora, COSep 15, 1969 · N8803S · Substantial damage NTSB DEN70D0116Accident · No injuriesClosedCessna 150F · Calhan, COSep 6, 1969 · N7808F · Substantial damage NTSB DEN70D0082Accident · No injuriesClosedCessna 150 · La Junta, COJun 19, 1969 · N8087F · Substantial damage NTSB DEN70D0006Accident · Minor injuriesClosedCessna 150F · Aurora, COMay 17, 1969 · N8623G · Substantial damage NTSB DEN69A0030Accident · Minor injuriesClosedCessna 150 · Aurora, CODec 26, 1968 · N6253R · 2 aircraft · Substantial damage NTSB DEN69D0143Accident · No injuriesClosedCessna 150 · Colo Springs, COOct 17, 1968 · N8880G · Substantial damage NTSB DEN69D0025Accident · Minor injuriesClosedCessna 150 · Eaton, COJun 16, 1968 · N3051X · Substantial damage NTSB DEN68D0273Accident · Minor injuriesClosedCessna 150 · Longmont, COMay 3, 1968 · N8435G · Substantial damage NTSB DEN68D0234Accident · No injuriesClosedCessna 150 · Cortez, COMar 23, 1968 · N3076X · Substantial damage NTSB DEN68D0216Accident · No injuriesClosedCessna 150 · Center, COJan 20, 1968 · N6420F · Destroyed NTSB DEN68D0136Accident · No injuriesClosedCessna 150 · Watkins, COOct 17, 1967 · N7942F · Substantial damage NTSB DEN68D0118Accident · Minor injuriesClosedCessna 150 · Loveland, COOct 2, 1967 · N3557L · Substantial damage NTSB DEN68F0098Accident · No injuriesClosedCessna 150 · Lamar, COSep 17, 1967 · N6623F · Substantial damage NTSB DEN68D0035Accident · No injuriesClosedCessna 150 · Broomfield, COJul 22, 1967 · N6640F · Substantial damage NTSB DEN68F0012Accident · Serious injuriesClosedCessna 150 · Watkins, COJul 5, 1967 · N7140F · Substantial damage NTSB DEN67D0280Accident · No injuriesClosedCessna 150 · Ft Morgan, COMay 14, 1967 · N8029F · Substantial damage NTSB DEN67F0230Accident · Minor injuriesClosedCessna 150 · Broomfield, COMar 30, 1967 · N8270F · Substantial damage NTSB DEN67D0196Accident · Minor injuriesClosedCessna 150F · Longmont, COJan 31, 1967 · N8701S · Substantial damage NTSB DEN67D0179Accident · No injuriesClosedCessna 150 · Montrose, CODec 5, 1966 · N8804S · Substantial damage NTSB DEN67D0155Accident · No injuriesClosedCessna 150 · Aurora, CONov 14, 1966 · N8056F · Substantial damage NTSB DEN67A0031Accident · 2 fatalClosedCessna 150F · Erie, CONov 5, 1966 · N7981F · Destroyed NTSB DEN67D0079Accident · No injuriesClosedCessna 150 · Denver, COJul 25, 1966 · N8023S · Substantial damage NTSB DEN67D0033Accident · No injuriesClosedCessna 150 · Elizabeth, COJul 3, 1966 · N8784S · Substantial damage NTSB DEN66D0347Accident · No injuriesClosedCessna 150 · Trinidad, COMay 1, 1966 · N7729F · Substantial damage NTSB DEN66F0312Accident · No injuriesClosedCessna 150F · Cortez, COApr 13, 1966 · N7083F · Substantial damage NTSB DEN66D0212Accident · No injuriesClosedCessna 150 · Littleton, CODec 20, 1965 · N8435G · Substantial damage NTSB DEN66F0183Accident · No injuriesClosedCessna 150 · Pueblo, CONov 8, 1965 · N8618S · Substantial damage