Skip to content

NTSB investigations: Cessna 150G, KS

32 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" = 'KS' 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\" = 'KS' 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" = 'KS' 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 CEN26LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Ellsworth, KSThe pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to complete the flight.Jul 10, 2026 · N3773J · Substantial damage NTSB CHI99LA195Accident · No injuriesLimited investigationFinal reportCessna 150G · Fort Scott, KSThe pilot's failure to maintain directional control during the landing roll. A factor to the accident was the soft terrain condition.Jun 25, 1999 · N2263J · Substantial damage NTSB MKC84LA227Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, KSShortly after takeoff the acft collided with wires and crashed. The plt had tried to fly under the wires because the acft would not climb over them. Investigation revealed that the acft was overloaded and out of balance by having 2 minorpassengers in the…Jul 21, 1984 · N2730S · Substantial damage NTSB MKC83LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Fredonia, KSThe acft bounced during landing & then landed hard on the nose gear which collapsed. The plt stated there was low-level turbulence. The plt was not entered into any formal training program nor did he have an instructor. He had accumulated about 12 hrs of dual…May 9, 1983 · N8317J · Substantial damage NTSB MKC82DA125Accident · No injuriesFinal reportCessna 150G · Bonner Springs, KSThe aircraft was flown from a private airstrip at maximum gross weight and an uphill takeoff run. The pilot stated he could not maintain airspeed. During a turn to make an emergency landing the left wing contacted a utility wire and the aircraft was…Jul 15, 1982 · N3335J · Substantial damage NTSB MKC80FA016Accident · 1 fatalClosedCessna 150G · Anthony, KSDec 22, 1979 · N8409J · Destroyed NTSB MKC80FCQ05Accident · Minor injuriesClosedCessna 150G · Onaga, KSDec 9, 1979 · N3165X · Substantial damage NTSB MKC76DCQ64Accident · No injuriesClosedCessna 150G · Oxford, KSJul 5, 1976 · N3221J · Substantial damage NTSB MKC76DCG68Accident · No injuriesClosedCessna 150 · Garnett, KSApr 3, 1976 · N3658J · Substantial damage NTSB MKC75FCG13Accident · No injuriesClosedCessna 150 · Kansas City, KSSep 8, 1974 · N3369J · Substantial damage NTSB MKC72DCQ60Accident · Serious injuriesClosedCessna 150 · Phillipsburg, KSJun 16, 1972 · N4673X · Minor damage NTSB MKC72DCG29Accident · Serious injuriesClosedCessna 150 · Leawood, KSOct 17, 1971 · N2494J · No damage NTSB MKC71DCQ45Accident · No injuriesClosedCessna 150 · Junctn City, KSJun 19, 1971 · N3920J · Substantial damage NTSB MKC71AK012Accident · 2 fatalClosedCessna 150G · Stanley, KSSep 6, 1970 · N3627J · Destroyed NTSB MKC70D0033Accident · No injuriesClosedCessna 150 · Leawood, KSMay 30, 1969 · N2494J · Substantial damage NTSB MKC70D0001Accident · Minor injuriesClosedCessna 150 · Ottawa, KSMay 25, 1969 · N3791J · Substantial damage NTSB MKC69D0431Accident · No injuriesClosedCessna 150 · Stilwell, KSMar 27, 1969 · N3454J · Substantial damage NTSB MKC69D0366Accident · No injuriesClosedCessna 150G · Bonner Sprgs, KSMar 9, 1969 · N4673X · Substantial damage NTSB MKC69D0351Accident · Minor injuriesClosedCessna 150 · Rantoul, KSJan 24, 1969 · N2877S · Substantial damage NTSB MKC69D0233Accident · No injuriesClosedCessna 150 · Kansas City, KSSep 29, 1968 · N22595 · 2 aircraft · Substantial damage NTSB MKC68D0603Accident · No injuriesClosedCessna 150 · Derby, KSJun 21, 1968 · N8568J · Substantial damage NTSB MKC68D0476Accident · No injuriesClosedCessna 150 · Russell, KSFeb 28, 1968 · N4797X · Substantial damage NTSB MKC68D0168Accident · No injuriesClosedCessna 150 · Emporia, KSSep 4, 1967 · N3854J · Substantial damage NTSB MKC68D0169Accident · No injuriesClosedCessna 150 · Rosehill, KSAug 22, 1967 · N8568J · Substantial damage NTSB MKC68D0200Accident · Minor injuriesClosedCessna 150 · Bennington, KSJul 1, 1967 · N4780X · Substantial damage NTSB MKC68F0014Accident · No injuriesClosedCessna 150G · Goddard, KSJun 22, 1967 · N2698J · Substantial damage NTSB MKC67D0586Accident · No injuriesClosedCessna 150 · Hays, KSApr 18, 1967 · N8501J · Substantial damage NTSB MKC67D0496Accident · No injuriesClosedCessna 150 · Brookville, KSMar 12, 1967 · N2465J · Substantial damage NTSB MKC67F0420Accident · Minor injuriesClosedCessna 150 · Goddard, KSDec 15, 1966 · N2213J · Substantial damage NTSB MKC67F0422Accident · No injuriesClosedCessna 150G · Manhattan, KSDec 13, 1966 · N3805J · Substantial damage NTSB MKC67F0498Accident · No injuriesClosedCessna 150G · Bogue, KSDec 10, 1966 · N3953J · Substantial damage NTSB MKC67D0305Accident · No injuriesClosedCessna 150 · Cheney, KSNov 2, 1966 · N3160X · Substantial damage