NTSB investigations: Cessna 150M, WV
6 cases on aircraft the registry lists as Cessna 150M. 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.
Cases per year
| 1977 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1998 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2071830'))
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 ('2071830'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC99LA001Accident · No injuriesLimited investigationFinal reportCessna 150M · Wiley Ford, WVWas the failure of the pilot to maintain directional control during an unforecast change in wind velocity. Factors were the gusts and the lack of recent experience for the pilot.NTSB BFO92LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glenville, WVThe pilot failed to follow the takeoff procedure which to led to a partial loss of power during takeoff. Contributing to the accident was the trees.NTSB BFO88FA022Accident · 1 fatalField investigationFinal reportCessna 150M · So. Charleston, WVThe stu plt said the engine began to alternate between partial and full power during the initial tkf climb. The acft was about 100 ft AGL and about 300 ft past the rwy end. According to the stu the inst took control of the acft, turned left, reversed course…NTSB ATL84LA207Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Parsons, WVThe acft collided with a tree and crashed after becoming lost in IMC weather during a night x-country. The plt had descended after seeing lights below him. He circled the town and made a turn to approach a road for landing on which he said the police had…NTSB ATL84LA010Accident · No injuriesLimited investigationFinal reportCessna C-150 · Parkersburg, WVThe acft collided with a deer during climbout on a night training mission. The weather was VMC but the night was dark. The CFI said they were doing touch and go landings. After completing a landing and during climbout the acft struck a deer. The acft was…NTSB IAD77FIJ07Accident · Minor injuriesClosedCessna 150 · Charleston, WV