Skip to content

NTSB investigations: Cessna 150G, VA

22 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

19672026

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" = 'VA' 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\" = 'VA' 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" = 'VA' 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 ERA23FA131Accident · 1 fatalClass 3 · FieldFinal reportCessna 150G · Hillsville, VAThe pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into terrain.Feb 27, 2023 · N2991J · Substantial damage NTSB NYC06FA215Accident · 2 fatalField investigationFinal reportCessna 150G · Penhook, VAThe pilot's failure to maintain aircraft control during climb, which resulted in exceeding the design stress limits of the airplane, and an in-flight breakup. Factors associated with the accident were the pilot's continued visual flight rules flight into…Sep 4, 2006 · N2932J · Destroyed NTSB NYC97LA192Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest, VAthe pilot's movement of the mixture control to the idle cut-off position, during an approach to land, which resulted in a loss of engine power and a forced landing before reaching the runway.Sep 24, 1997 · N4748X · Substantial damage NTSB BFO91LA059Accident · No injuriesLimited investigationFinal reportCessna 150G · Stuart, VAThe pilot's failure to observe a hidden object while landing in an open field.Jun 26, 1991 · N2641J · Substantial damage NTSB BFO90FA070Accident · 2 fatalField investigationFinal reportCessna 150G · Ridgeway, VAFailure of the pilot to maintain adequate airspeed, which resulted in a stall and inflight collision with the terrain.Aug 14, 1990 · N459AE · Destroyed NTSB BFO88LA029Accident · No injuriesLimited investigationFinal reportCessna 150G · Ridgeway, VADuring touchdown the acft bounced and the student plt applied power to level-off and reflare. The left wing then rose and the right wing contacted the rwy. The acft bounced back and the left wing contacted the rwy. The nose gear collapsed and the acft came to…Mar 22, 1988 · N6360S · Substantial damage NTSB BFO87LA033Accident · No injuriesLimited investigationFinal reportCessna 150G · Roanoke, VAWhile enroute from gaithersburg, MD, to blacksburg, VA, the plt decided to divert to Roanoke, VA, due to thunderstorms in the area. On x-wind leg to rwy 33 at Roanoke the eng started to run rough. Aft carb heat was applied it smoothed out but quit completely…Apr 28, 1987 · N3043S · Substantial damage NTSB ATL84LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Charlottesville, VAThe plt reported that he started to lose control during the landing and added power to go-around. He said he pulled backon the controls and inadvertantly raised the flaps after he was already losing altitude. After touchdown, the acft flipped over.Jan 7, 1984 · N2462J · Substantial damage NTSB ATL81FID02Accident · Minor injuriesClosedCessna 150G · Roanoke, VANov 13, 1980 · N3251J · Destroyed NTSB IAD74AI048Accident · 1 fatalClosedCessna 150G · Jewell Ridge, VAFeb 28, 1974 · N3230X · Destroyed NTSB NYC73AN006Accident · 1 fatalClosedCessna 150G · Arcola, VAJul 6, 1972 · N8442J · Destroyed NTSB NYC72FID25Accident · Minor injuriesClosedCessna 150G · Chesterfield, VAApr 29, 1972 · N2604J · Destroyed NTSB NYC72FID21Accident · No injuriesClosedCessna 150 · Charles City, VAMar 4, 1972 · N8570J · Substantial damage NTSB IAD71DID19Accident · No injuriesClosedCessna 150G · Ft Eustis, VAJan 13, 1971 · N3091S · Substantial damage NTSB DIA70D0004Accident · No injuriesClosedCessna 150 · Front Royal, VAJun 16, 1969 · N4099J · Substantial damage NTSB DIA69D0140Accident · No injuriesClosedCessna 150 · Norfolk, VAJan 16, 1969 · N2604J · Substantial damage NTSB DIA69F0098Accident · No injuriesClosedCessna 150 · Topping, VAOct 23, 1968 · N8678J · Substantial damage NTSB DIA68D0143Accident · No injuriesClosedCessna 150G · Crewe, VADec 31, 1967 · N8535J · Substantial damage NTSB DIA68D0115Accident · No injuriesClosedCessna 150G · Basye, VAOct 24, 1967 · N3711J · Substantial damage NTSB DIA68D0080Accident · No injuriesClosedCessna 150 · New Kent, VAOct 3, 1967 · N6287S · Substantial damage NTSB DIA68A0014Accident · 2 fatalClosedCessna 150G · Fincastle, VAOct 2, 1967 · N8665J · Destroyed NTSB DIA67F0110Accident · No injuriesClosedCessna 150G · Sandston, VAMay 23, 1967 · N4629X · Substantial damage