NTSB investigations: Cessna 150L, SD
9 cases on aircraft the registry lists as Cessna 150L. 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
| 1973 | 1 |
|---|---|
| 1974 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2008 | 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\" = 'SD' 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 ('2071826'))
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" = 'SD' 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 ('2071826'))
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 CHI08CA235Accident · Minor injuriesData collectionFinal reportCessna 150L · Watertown, SDThe pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.NTSB CHI98LA307Accident · No injuriesLimited investigationFinal reportCessna 150L · Philip, SDthe fuel exhaustion due to the pilot's inadequate preflight inspection. A factor was the soft field.NTSB CHI94LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Waubay, SDthe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the false indications on the fuel gauges.NTSB CHI91LA270Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Watertown, SDAttempted formation flying with N4535E by the pilot of N16098. Factors associated with the collision were: nonperformance of preflight planning, and failure to follow procedures and directives by the pilot of N16098.NTSB DEN88LA028Accident · No injuriesLimited investigationFinal reportCessna 150L · Aberdeen, SDThe private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported…NTSB MKC80FA020Accident · 2 fatalClosedCessna 150 · Sioux Falls, SDNTSB MKC79FTK05Accident · No injuriesClosedCessna 150 · Parkston, SDNTSB MKC74AK065Accident · 1 fatalClosedCessna 150L · Kranzburg, SDNTSB MKC74AK034Accident · 1 fatalClosedCessna 150L · Turton, SD