Skip to content

NTSB investigations: Cessna 150G, CO

28 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" = '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 ('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\" = '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 ('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" = '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 ('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 CEN26LA156Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 150G · Ellicott, COOn March 21, 2026, about 1023 mountain daylight time, a Cessna 150G airplane, N6305S, was substantially damaged when it was involved in an accident near Ellicott, Colorado. The pilot sustained serious injuries. The airplane was operated as a Title 14 Code of…Mar 21, 2026 · N6305S · Substantial damage NTSB CEN13CA532Accident · No injuriesData collectionFinal reportCessna 150G · Denver, COThe pilot's failure to maintain directional control during landing which resulted in an impact with the runway surface. A contributing factor was the certified flight instructor delayed response to the pilot's improper landing.Sep 6, 2013 · N4791X · Substantial damage NTSB DEN81FTE52Accident · No injuriesClosedCessna 150G · Hudson, COJul 1, 1981 · N2934J · Substantial damage NTSB DEN78FTE30Accident · 1 fatalClosedCessna 150G · Ft Garland, COFeb 18, 1978 · N6244S · Destroyed NTSB DEN78FA005Accident · 1 fatalClosedCessna 150G · Kiowa, COOct 28, 1977 · N3373J · Destroyed NTSB DEN77FTE68Accident · No injuriesClosedCessna 150 · Co Springs, COAug 1, 1977 · N3635J · Substantial damage NTSB DEN76DTE47Accident · No injuriesClosedCessna 150 · Craig, COJan 4, 1976 · N2956J · Substantial damage NTSB DEN73FTE89Accident · Minor injuriesClosedCessna 150 · Holly, COJun 24, 1973 · N2983J · Substantial damage NTSB DEN72FTE66Accident · No injuriesClosedCessna 150G · Englewood, COMar 23, 1972 · N6250S · Substantial damage NTSB DEN72DTE52Accident · Minor injuriesClosedCessna 150 · Walsenburg, CODec 27, 1971 · N3082S · Substantial damage NTSB DEN72DTE43Accident · No injuriesClosedCessna 150G · Broomfield, CONov 13, 1971 · N3484J · Substantial damage NTSB DEN72FTE34Accident · No injuriesClosedCessna 150 · Aurora, COOct 20, 1971 · N3731J · Substantial damage NTSB DEN72FTE01Accident · Serious injuriesClosedCessna 150 · Aurora, COJul 3, 1971 · N8403J · Substantial damage NTSB DEN70D0042Accident · No injuriesClosedCessna 150G · Longmont, COJul 24, 1969 · N3817J · Substantial damage NTSB DEN70D0068Accident · No injuriesClosedCessna 150G · Longmont, COJul 23, 1969 · N3721J · Substantial damage NTSB DEN69A0046Accident · 1 fatalClosedCessna 150G · Franktown, COMay 3, 1969 · N2649J · Destroyed NTSB DEN69D0021Accident · No injuriesClosedCessna 150 · Greeley, COJun 14, 1968 · N8442J · Substantial damage NTSB DEN69D0063Accident · No injuriesClosedCessna 120 · Fort Collins, COJun 12, 1968 · N77447 · 2 aircraft · Substantial damage NTSB DEN69D0007Accident · No injuriesClosedCessna 150 · Denver, COMay 22, 1968 · N6250S · Substantial damage NTSB DEN68D0246Accident · No injuriesClosedCessna 150 · Fort Collins, COApr 10, 1968 · N3782J · Destroyed NTSB DEN68D0111Accident · No injuriesClosedCessna 150 · Pierce, COOct 15, 1967 · N3614J · Substantial damage NTSB DEN68F0119Accident · Minor injuriesClosedCessna 150G · Aurora, COOct 10, 1967 · N4077J · Substantial damage NTSB DEN68D0076Accident · No injuriesClosedCessna 150 · Sedalia, COAug 20, 1967 · N3285J · Substantial damage NTSB DEN68D0057Accident · Minor injuriesClosedCessna 150 · Aurora, COAug 2, 1967 · N4613X · Substantial damage NTSB DEN67F0297Accident · No injuriesClosedCessna 150G · Grand Junctn, COJun 1, 1967 · N4611X · Substantial damage NTSB DEN67D0255Accident · No injuriesClosedCessna 150G · Rangely, COApr 19, 1967 · N4016J · Substantial damage NTSB DEN67F0195Accident · No injuriesClosedCessna 150G · Loveland, COJan 21, 1967 · N2224J · Substantial damage NTSB DEN67D0167Accident · No injuriesClosedCessna 150 · Logmont, CONov 30, 1966 · N3817J · Substantial damage