NTSB investigations: Cessna 152, WV

9 cases on aircraft the registry lists as Cessna 152. 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

19812026

NTSB investigations: Cessna 152, WV per year, 1981–2026: 9 cases
1981	2
1982	1
1983	1
1986	1
1990	2
1995	1
1998	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" = 'WV' 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 ('2071835')) 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\" = 'WV' 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 ('2071835'))
  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" = 'WV' 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 ('2071835'))
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 NYC98LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Philippi, WVWas the failure of an exhaust valve. A factor in the accident was the unsuitable landing area encountered by the pilot.Jul 20, 1998 · N69193 · Substantial damage NTSB BFO95LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Martinsburg, WVthe student pilot's failure to maintain control of the airplane during the landing/aborted landing sequence. A related factor is the student pilot's lack of total flight experience.Aug 30, 1995 · N68969 · Substantial damage NTSB BFO91LA005Accident · No injuriesLimited investigationFinal reportCessna C152 · Bridgeport, WVThe pilot's inability to avoid a collision with deer which had moved onto the runway during their takeoff roll. The dark night contributed to the accident by limiting the pilots' visual outlook.Oct 20, 1990 · N757RM · Substantial damage NTSB BFO90LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Grafton, WVThe pilot's improper use of carburetor heat, when operating at reduced power in conditions which were conducive to carburetor ice.Mar 1, 1990 · N65538 · Substantial damage NTSB ATL86LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Charleston, WVThe plt flew the aircraft twice, another plt flew it once then the plt attempted another flight. He reported to app control that he thought he was out of fuel. An off airport landing was attempted. Examination of the aircraft showed less than one gallon of…Sep 1, 1986 · N66989 · Substantial damage NTSB ATL84LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Huntington, WVAcft ballooned during the landing portion of a touch-&-go. The student added power & the acft stalled in a nose high attitude. The acft dropped to the rwy from about 10 ft.Nov 26, 1983 · N49440 · Substantial damage NTSB ATL82DA117Accident · Minor injuriesFinal reportCessna 152 · White Sulphur S, WVThe pilot took off on runway 26 with a full load of fuel, one passenger, and luggage. The aircraft was at or near its maximum gross weight limit. The temperature was 60 degrees. The airport elevation was 1801 ft MSL and two ridge lines ran parallel to the…Apr 30, 1982 · N49924 · Destroyed NTSB ATL81DIJ14Accident · No injuriesClosedCessna 152 · Smithville, WVSep 29, 1981 · N64833 · Substantial damage NTSB ATL81DIJ07Accident · No injuriesClosedCessna 152 · Bridgeport, WVMay 8, 1981 · N5440M · Substantial damage