NTSB investigations: Cessna 150F, SC
20 cases on aircraft the registry lists as Cessna 150F. 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
| 1966 | 4 |
|---|---|
| 1967 | 3 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 2 |
| 1974 | 2 |
| 1979 | 1 |
| 1986 | 1 |
| 1999 | 1 |
| 2011 | 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 ('2071814'))
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 ('2071814'))
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 ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.NTSB MIA99LA112Accident · No injuriesLimited investigationFinal reportCessna 15OF · Columbia, SCThe pilots failure to maintain a visual lookout during a forced landing to a highway. This resulted in the left main landing gear colliding with a rain grate separating the left main landing gear. Contributing to the accident was a total loss of engine power…NTSB ATL86FA116Accident · Minor injuriesField investigationFinal reportCessna 150M · Gaston, SCTwo aircraft collided and were substantially damaged during landing flare/touchdown at the uncontrolled airport. Both aircraft flew a left hand traffic pattern at a pattern altitude of 1000 ft MSL. A witness to the accident related that one aircraft flew…NTSB MIA80DLG02Accident · No injuriesClosedCessna 150 · Moncks Corner, SCNTSB MIA75DLG16Accident · No injuriesClosedCessna 150 · Anderson, SCNTSB MIA74DLG22Accident · No injuriesClosedCessna 150 · N Myrtle Bch, SCNTSB MIA74FLG13Accident · No injuriesClosedCessna 150F · Barnwell, SCNTSB MIA73DLG37Accident · No injuriesClosedCessna 150F · Timmonsville, SCNTSB MIA73DLG16Accident · No injuriesClosedCessna 150 · Waterboro, SCNTSB MIA72DLG31Accident · No injuriesClosedCessna 150 · Pelzer, SCNTSB MIA72DLG02Accident · Minor injuriesClosedCessna 150F · Harleyville, SCNTSB MIA70DLG10Accident · Minor injuriesClosedCessna 150 · Gaffney, SCNTSB MIA69A0024Accident · 2 fatalClosedCessna 150 · Orangeburg, SCNTSB MIA68D0357Accident · No injuriesClosedCessna 150F · Clemson, SCNTSB DIA68D0038Accident · Minor injuriesClosedCessna 150 · Little River, SCNTSB MIA67F0498Accident · Minor injuriesClosedCessna 150F · Charleston, SCNTSB MIA67D0260Accident · No injuriesClosedCessna 150 · Hartsville, SCNTSB MIA67D0130Accident · No injuriesClosedCessna 150 · Johns Island, SCNTSB MIA66F0594Accident · No injuriesClosedCessna 150F · Crescent Beach, SCNTSB MIA66F0420Accident · No injuriesClosedCessna 150 · Lake Murray, SC