NTSB investigations: Cessna 150J, OR
17 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
| 1970 | 3 |
|---|---|
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1976 | 2 |
| 1979 | 3 |
| 1980 | 1 |
| 1983 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 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\" = 'OR' 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" = 'OR' 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 SEA94FA247Accident · 1 fatalField investigationFinal reportCessna 150J · Roseburg, ORthe pilot's failure to maintain clearance from the terrain.NTSB SEA92LA080Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Sunriver, ORThe pilot did not accurately calculate fuel consumption. A factor to the accident was: fuel exhaustion.NTSB SEA91LA096Accident · No injuriesLimited investigationFinal reportCessna 150J · Mulino, ORThe pilot's inadequate remedial action. Factors include nose-gear vibration.NTSB SEA83LA169Accident · No injuriesLimited investigationFinal reportCessna 150J · Grants Pass, ORThe acft ran off the departure end of the rwy during a forced landing following engine failure during a touch and go landing. The nosewheel struck a mound of dirt and the acft nosed over. The acft had reached 40 ft AGL and 70 mph when the engine lost power…NTSB SEA80DYM48Accident · No injuriesClosedCessna 150J · Long Creek, ORNTSB SEA79DYK26Accident · No injuriesClosedCessna 150 · Burns, ORNTSB SEA79DYM53Accident · No injuriesClosedCessna 150 · Pilot Rock, ORNTSB SEA79FYM52Accident · Serious injuriesClosedCessna 150 · Sisters, ORNTSB SEA77DYC09Accident · Minor injuriesClosedCessna 150 · Cornelius, ORNTSB SEA76DYC47Accident · No injuriesClosedCessna 150 · Clackamas, ORNTSB SEA76AS023Accident · 2 fatalClosedCessna 150J · Grants Pass, ORNTSB UNK75X0106Accident · No injuriesClosedCessna 150 · Chemult, ORNTSB SEA74DYC42Accident · No injuriesClosedCessna 150J · Molalla, ORNTSB SEA74DYI02Accident · No injuriesClosedCessna 150J · Rogue River, ORNTSB SEA71DWA18Accident · Minor injuriesClosedCessna 150 · Gaston, ORNTSB SEA70AS046Accident · 2 fatalClosedCessna 150J · Lacomb, ORNTSB SEA70DWA08Accident · No injuriesClosedCessna 150 · Newport, OR