NTSB investigations: Cessna 150H, VA

12 cases on aircraft the registry lists as Cessna 150H. 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

19692026

NTSB investigations: Cessna 150H, VA per year, 1969–2026: 12 cases
1969	2
1970	1
1972	1
1975	1
1980	1
1984	1
1985	1
1987	1
1991	1
1999	1
2009	1

Where

Open the map

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 ('2071818')) 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 ('2071818'))
  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 ('2071818'))
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 ERA09LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Lawrenceville, VAA loss of engine power due to carburetor icing.Jun 13, 2009 · N22075 · Substantial damage NTSB NYC99LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, VAThe pilot's failure to adequately calculate required fuel for the flight, which resulted in a total loss of engine power.Jul 6, 1999 · N22600 · Substantial damage NTSB BFO92LA001Accident · No injuriesLimited investigationFinal reportCessna 150H · Saluda, VAThe pilot's decision to abort the takeoff with inadequate runway to stop. A factor in the accident was the failure of the exhaust muffler baffle.Oct 18, 1991 · N23398 · Substantial damage NTSB BFO87LA044Accident · No injuriesLimited investigationFinal reportCessna 150H · Hot Springs, VAOn the second leg of a cross-country flight from annapolis, MD to albuquerque, NM, the pilot became disoriented and was unable to locate ingalls airport in Hot Springs, VA. The pilot realized he was low on fuel and decided to make a precautionary landing on a…Jun 30, 1987 · N23106 · Substantial damage NTSB BFO85LA029Accident · Minor injuriesLimited investigationFinal reportCessna 150H · South Hill, VAWhile on a solo cross country flight the student pilot became disorientated after about 60MIN of flt. He atmptd to call in the blind on guard. Freq. Both danville and roanok fss's responded to his calls but were unable to establish 2 way commo with the plt.…Mar 16, 1985 · N23231 · Substantial damage NTSB ATL85LA040Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Bumpass, VAVFR plt was using VOR airway navigation. He arrived in the vicinity of destination after dark and attempted to locate the arpt by flying a radial from the VOR; however, he used the 230 degree radial (published radial is 237 degrees). Further, the arpt is…Nov 20, 1984 · N22741 · Substantial damage NTSB ATL80DID22Accident · Minor injuriesClosedCessna 150 · Meherrin, VAJun 14, 1980 · N23092 · Substantial damage NTSB DCA75AZ008Accident · 9 fatalClosedCessna 150H · Newport News, VAJan 9, 1975 · N50430 · 2 aircraft · Destroyed NTSB NYC72FID34Accident · No injuriesClosedCessna 150H · Newport News, VAMay 16, 1972 · N22984 · Substantial damage NTSB IAD70AI055Accident · 1 fatalClosedCessna 150H · Burke, VAApr 1, 1970 · N7173S · Destroyed NTSB IAD70D0099Accident · No injuriesClosedCessna 150 · Pound, VAOct 16, 1969 · N22648 · Substantial damage NTSB DIA70D0051Accident · No injuriesClosedCessna 150 · Fredericksburg, VAAug 11, 1969 · N23491 · Substantial damage