NTSB investigations: Cessna 150G, SC
12 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 | 1 |
|---|---|
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1989 | 1 |
| 1997 | 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\" = 'SC' 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" = 'SC' 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 MIA97LA184Accident · No injuriesLimited investigationFinal reportCessna 150G · Greer, SCthe student pilot's improper management of fuel, which resulted in fuel exhaustion, loss of engine power, and subsequent collision with trees and terrain.NTSB ATL89LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Edgefield, SCPoor inflight planning by the pilot in command in that he allowed the fuel supply to be exhausted.NTSB MIA74DLG33Accident · No injuriesClosedCessna 150 · Mullins, SCNTSB MIA74FLG28Accident · No injuriesClosedCessna 150G · Charleston, SCNTSB MIA73DLG52Accident · No injuriesClosedCessna 150 · New Ellenton, SCNTSB MIA73FLG44Accident · Serious injuriesClosedCessna 150B · Columbia, SCNTSB MIA73DLG09Accident · No injuriesClosedCessna 150G · Charleston, SCNTSB MIA70DLG14Accident · No injuriesClosedCessna 150 · Moncks Corner, SCNTSB MIA69D0447Accident · Serious injuriesClosedCessna 150 · Clemson, SCNTSB MIA69F0277Accident · No injuriesClosedCessna 150G · Fountain Inn, SCNTSB MIA68D0509Accident · Minor injuriesClosedCessna 150G · Lancaster, SCNTSB MIA67D0537Accident · Minor injuriesClosedCessna 150G · Winnsboro, SC