Skip to content

NTSB investigations: Cessna 150G, OR

23 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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 SEA99LA058Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Detroit, ORThe pilot's inadvertent visual flight rules flight into instrument meteorological conditions, eventually resulting in a non-mechanical loss of engine power. Factors were: the pilot's inadequate preflight planning and preparation; a snowstorm with icing…May 7, 1999 · N3381J · Substantial damage NTSB SEA95LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Florence, ORThe pilot-in-command's failure to properly recover from a bounced landing, and his failure to compensate for wind conditions and maintain directional control during the landing rollout. Contributing to the accident were gusty crosswinds.Oct 4, 1994 · N3164X · Substantial damage NTSB SEA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pendleton, ORFuel exhaustion due to the pilot's failure to refuel. Factors contributing to the accident were the pilot's becoming lost/disoriented and soft terrain.Apr 22, 1993 · N3163X · Substantial damage NTSB SEA93LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Jordan Valley, ORThe pilot continued the VFR flight into IMC and failed to maintain clearance from obstacles on the ground. Factors relating to the accident were the clouds, low ceiling, and rain.Mar 26, 1993 · N3986J · Destroyed NTSB SEA87LA148Accident · No injuriesLimited investigationFinal reportCessna 150G · Gresham, ORDuring the student pilot's long solo cross-crounty a loss of power occurred. During the forced landing the pilot overshot the intended field so he selected a nearby field. He overshot this field, flew between 2 trees at 20 feet AGL and descended to the…Jul 25, 1987 · N2415J · Substantial damage NTSB SEA83LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Scappoose, ORAt about 300 ft AGL after a touch & go the eng quit. The non-pilot owner who was at the controls turned the acft over to the passenger who was a private pilot & he made the forced landing. There was no usuable fuel on board the acft the passenger/pilot…Dec 26, 1982 · N2239J · Substantial damage NTSB SEA81DYK13Accident · No injuriesClosedCessna 150G · Medford, ORJul 21, 1981 · N2800S · Substantial damage NTSB SEA80FYM09Accident · Serious injuriesClosedCessna 150G · Aloha, ORDec 10, 1979 · N4825X · Substantial damage NTSB SEA77DYK24Accident · Minor injuriesClosedCessna 150 · Ashland, ORSep 23, 1977 · N2646J · Substantial damage NTSB SEA75AS027Accident · 1 fatalClosedCessna 150H · Newberg, ORJan 13, 1975 · N3701J · Destroyed NTSB LAX74DYI11Accident · No injuriesClosedCessna 150 · Medford, ORApr 7, 1974 · N2800S · 2 aircraft · Substantial damage NTSB SEA74FYC09Accident · No injuriesClosedCessna 150 · Baker, ORAug 12, 1973 · N4827X · Substantial damage NTSB SEA73ASO08Accident · 1 fatalClosedCessna 150G · Portland, OROct 4, 1972 · N8320J · Destroyed NTSB SEA72FYI08Accident · Serious injuriesClosedCessna 150G · Paisley, ORAug 26, 1971 · N3837J · Destroyed NTSB SEA72FYC11Accident · No injuriesClosedCessna 150 · Albany, ORJul 27, 1971 · N3625J · Substantial damage NTSB SEA71DWA27Accident · No injuriesClosedCessna 150 · Albany, ORJan 26, 1971 · N3625J · Substantial damage NTSB SEA71DVQ06Accident · No injuriesClosedCessna 150 · Christmas V, ORAug 8, 1970 · N4024J · Substantial damage NTSB SEA70DWA05Accident · No injuriesClosedCessna 150 · Cottage Grve, ORFeb 22, 1970 · N3139J · Substantial damage NTSB SEA70D0001Accident · No injuriesClosedCessna 150 · Albany, ORApr 20, 1969 · N4046J · Substantial damage NTSB SEA68F0278Accident · Minor injuriesClosedCessna 150 · Dillard, ORMar 11, 1968 · N3099S · Substantial damage NTSB SEA68D0179Accident · No injuriesClosedCessna 150G · Wasco, ORAug 27, 1967 · N3292J · Substantial damage NTSB SEA68D0171Accident · No injuriesClosedCessna 150G · North Bend, ORAug 23, 1967 · N4024J · Substantial damage NTSB SEA67F0184Accident · Minor injuriesClosedCessna 150 · Springfield, ORSep 5, 1966 · N3690J · Substantial damage