NTSB investigations: Cessna 150M, NV
12 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 | 2 |
|---|---|
| 1978 | 1 |
| 1979 | 4 |
| 1980 | 1 |
| 1981 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1993 | 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 ('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" = '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 ('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 LAX94LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Las Vegas, NVthe student pilot's failure to execute a go-around, premature flare, and improper use of the flight controls. Factors related to this accident are the student pilot's lack of total experience and diverted attention.NTSB LAX91LA197Accident · No injuriesLimited investigationFinal reportCessna 150 · Fernley, NVThe failure of the pilot to adequately assess the climb performance of the accident airplane due to being under the influence of alcohol.NTSB SEA87LA154Accident · No injuriesLimited investigationFinal reportCessna 150M · Austin, NVThe plt was flying up a canyon when he realized the canyon was closing & he had no way of turning around. He was unable to outclimb rising terrain. Subsequently, the acft crashed into several small pine trees & was extensively damaged. The density alt at the…NTSB LAX81FA060Accident · 2 fatalClosedCessna 150 · Reno, NVNTSB LAX80FVW20Accident · No injuriesClosedCessna 150M · Las Vegas, NVNTSB LAX80FVW04Accident · No injuriesClosedCessna 150 · Las Vegas, NVNTSB LAX80FVW03Accident · No injuriesClosedCessna 150M · Las Vegas, NVNTSB LAX80DXQ04Accident · No injuriesClosedCessna 150M · Reno, NVNTSB OAK79FVW11Accident · No injuriesClosedCessna 150M · Las Vegas, NVNTSB OAK78FA024Accident · 2 fatalClosedCessna 150M · Carson City, NVNTSB OAK77FVW22Accident · No injuriesClosedCessna 150M · Las Vegas, NVNTSB OAK77DXQ05Accident · No injuriesClosedCessna 150 · Jackpot, NV