NTSB investigations: Cessna 150J, NV
9 cases on aircraft the registry lists as Cessna 150J. 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
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 2019 | 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\" = 'NV' 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 ('2071820'))
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" = 'NV' 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 ('2071820'))
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 GAA20CA010Accident · No injuriesData collectionFinal reportCessna 150 · Fallon, NVThe pilot's improper preflight fuel planning and quantity inspection, which resulted in fuel exhaustion, a total loss of engine power, a forced landing on unsuitable terrain, and a subsequent nose-over.NTSB SEA90LA049Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Valmy, NVThe pilots poor inflight planning and decision to land on an abandoned highway in strong gusty crosswind conditions, his improper remedial action of turning downwind at a low altitude after aborting the landing and his failure to maintain airspeed. Factors in…NTSB SEA87FA158Accident · 1 fatalField investigationFinal reportCessna 150J · Las Vegas, NVThe student plt planned a x-country flt for 3.6 hrs. After 3.9 hrs of flt, fuel exhaustion occurred as the acft was apchg the destn arpt. The plt declared an emergency, but was unable to glide to the arpt. Witnesses observed the acft on an apch to a vacant…NTSB OAK74DXQ39Accident · No injuriesClosedCessna 150 · Reno, NVNTSB OAK72FVW33Accident · No injuriesClosedCessna 150J · Goldfield, NVNTSB OAK71FVW37Accident · No injuriesClosedCessna 150J · Las Vegas, NVNTSB OAK71FVW23Accident · No injuriesClosedCessna 150J · Las Vegas, NVNTSB OAK71FVW10Accident · No injuriesClosedCessna 150 · Las Vegas, NVNTSB OAK70D0091Accident · Minor injuriesClosedCessna 150 · Tonopah, NV