NTSB investigations: Cessna 150J, CO
13 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 | 3 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1987 | 1 |
| 1991 | 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\" = 'CO' 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" = 'CO' 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 DEN91LA055Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Watkins, COLoss of engine power for an undetermined reason, and failure of the pilot to maintain airspeed during the forced landing, which resulted in a stall/mush.NTSB DEN87LA109Accident · No injuriesLimited investigationFinal reportCessna 150J · Longmont, COA student plt was practicing landings on her second supervised solo training flt. On the first approach, she failed to flare properly and hit in a three point attitude. The nose gear collapsed and the propeller struck the rwy. The acft skidded about 25 feet…NTSB DEN78DTE72Accident · No injuriesClosedCessna 150 · Sterling, CONTSB DEN77FA034Accident · 3 fatalClosedCessna 150 · Boulder, CONTSB DEN76FTE57Accident · Serious injuriesClosedCessna 150J · Broomfield, CONTSB DEN74AD052Accident · 1 fatalClosedCessna 150J · Sargents, CONTSB DEN74FTE12Accident · Minor injuriesClosedCessna 150 · Eldorado Spg, CONTSB DEN72DTE63Accident · No injuriesClosedCessna 150 · Arapahoe, CONTSB DEN71DXD53Accident · No injuriesClosedCessna 150J · Greeley, CONTSB DEN71DXD11Accident · No injuriesClosedCessna 150J · Limon, CONTSB DEN71DXD04Accident · No injuriesClosedCessna 150 · Englewood, CONTSB DEN70DXD26Accident · No injuriesClosedCessna 150 · Aurora, CONTSB DEN70A0031Accident · 1 fatalClosedCessna 150J · Eldora, CO