NTSB investigations: Cessna 150K, NV
6 cases on aircraft the registry lists as Cessna 150K. 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
| 1971 | 2 |
|---|---|
| 1978 | 1 |
| 1984 | 1 |
| 1986 | 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 ('2071822'))
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 ('2071822'))
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 LAX93LA175Accident · No injuriesLimited investigationFinal reportCessna 150K · Boulder City, NVThe instructor's inadequate bounced landing recovery and airspeed management during the attempted go around, which led to an inadvertent stall and the instructor's inadequate supervision of the flight. A factor in the accident was the instructor's low total…NTSB SEA86LA083Accident · No injuriesLimited investigationFinal reportCessna 150K · Las Vegas, NVWhile on final VFR approach to landing, total loss of power occurred. Acft landed short on rough terrain, collapsing the nose landing gear, and acft nosed over. Investigation found a quart of water in the fuel system. Acft had been parked outside three days…NTSB SEA84LA070Accident · No injuriesLimited investigationFinal reportCessna 150-K · Fallon, NVThe student plt said he was departing his privately owned strip & had a 7 ft fence to clear at the departure end. He reported that just as he became airborne, the acft encounter a gust of wind which caused the right wing to hit a fence post, then the acft…NTSB OAK78DXQ07Accident · Minor injuriesClosedCessna 150 · Pyramid Lake, NVNTSB OAK71FVW27Accident · No injuriesClosedCessna 150K · N.Las Vegas, NVNTSB OAK71FVW22Accident · No injuriesClosedCessna 150K · No.Las Vegas, NV