NTSB investigations: Cessna 150G, NV
15 cases on aircraft the registry lists as Cessna 150G. 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
| 1967 | 2 |
|---|---|
| 1969 | 5 |
| 1970 | 2 |
| 1971 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1978 | 2 |
| 2007 | 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 ('2071816'))
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 ('2071816'))
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 SEA07LA126Accident · 1 fatalLimited investigationFinal reportCessna 150G · Pahrump, NVThe loss of engine power due to fuel contamination followed by the pilot's failure to maintain aircraft control during takeoff. Contributing factors were the pilot's inadequate preflight and an inadequate 100-hour maintenance inspection by other maintenance…NTSB OAK78DXQ32Accident · Minor injuriesClosedCessna 182 · Minden, NVNTSB OAK78DXQ12Accident · No injuriesClosedCessna 150G · Reno, NVNTSB OAK76DXQ51Accident · No injuriesClosedCessna 150 · Reno, NVNTSB OAK74DXQ08Accident · No injuriesClosedCessna 150 · Winnemucca, NVNTSB OAK72FXQ12Accident · Serious injuriesClosedCessna 150G · Imlay, NVNTSB OAK70DXQ23Accident · No injuriesClosedCessna 150 · Valmy, NVNTSB OAK70FVW08Accident · No injuriesClosedCessna 150G · Las Vegas, NVNTSB OAK70F0010Accident · No injuriesClosedCessna 150H · Sparks, NVNTSB OAK70D0009Accident · No injuriesClosedCessna 150 · Winnemucca, NVNTSB OAK70F0007Accident · No injuriesClosedCessna 150 · Dyer, NVNTSB OAK69F0293Accident · No injuriesClosedCessna 150G · N Las Vegas, NVNTSB UNK69X0105Accident · No injuriesClosedCessna 150G · Las Vegas, NVNTSB OAK68A0034Accident · 2 fatalClosedCessna 150G · Las Vegas, NVNTSB OAK68D0140Accident · No injuriesClosedCessna 150 · Lund, NV