NTSB investigations: Cessna 150L, WV
8 cases on aircraft the registry lists as Cessna 150L. 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
| 1979 | 2 |
|---|---|
| 1981 | 2 |
| 1983 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1996 | 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 ('2071826'))
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 ('2071826'))
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 IAD96LA122Accident · 1 fatalLimited investigationFinal reportCessna 150L · Philippi, WVthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from trees, while maneuvering at low altitude. Intentional maneuvering at low altitude was a…NTSB BFO93LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVFailure of the pilots to properly clear the engine during the approach.NTSB BFO88LA027Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVAccording to the student plt, the acft crabbed to the left just prior to touchdown. Upon touchdown, the acft veered left and traveled off the rwy into muddy grass. Despite the plt's use of brakes and right rudder the acft continued down an embankment where it…NTSB ATL83FIG06Accident · Serious injuriesFinal reportCessna 150 · Petersburg, WVThe acft was unable to maintain altitude while crossing mountain ridges & stalled about 50 ft above a tree line. The pilots had been using automotive fuel during prefueling stopNTSB ATL81FIJ10Accident · No injuriesClosedCessna 150 · Hurricane, WVNTSB ATL81FIJ04Accident · No injuriesClosedCessna 150 · Buckhannon, WVNTSB IAD79DA085Accident · No injuriesClosedCessna 150 · Lansing, WVNTSB IAD79FGN34Accident · Minor injuriesClosedCessna 150 · Moundsville, WV