NTSB investigations: Cessna 150H, NC
13 cases on aircraft the registry lists as Cessna 150H. 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
| 1968 | 1 |
|---|---|
| 1969 | 2 |
| 1970 | 1 |
| 1976 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2016 | 1 |
| 2018 | 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\" = 'NC' 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 ('2071818'))
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" = 'NC' 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 ('2071818'))
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 GAA18CA235Accident · No injuriesData collectionFinal reportCessna 150 · Statesville, NCThe pilot’s failure to maintain crosswind correction during landing and the flight instructor’s delayed remedial action. Contributing to the accident was the pilot’s and flight instructor’s decision to land with gusting tailwinds.NTSB ERA17LA045Accident · No injuriesLimited investigationFinal reportCessna 150 · Snow Hill, NCThe total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB MIA98LA235Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Kill Devil Hill, NCFailure of the number one cylinder exhaust valve resulting in loss of engine power and a forced landing on unsuitable terrain at which time the aircraft nosed over.NTSB ATL95LA085Accident · No injuriesLimited investigationFinal reportCessna 150H · Bath, NCA bird, which collided with and fractured the aircraft windshield, resulting in an emergency landing. A factor was the soft terrain at the emergency landing site.NTSB ATL93LA146Accident · No injuriesLimited investigationFinal reportCessna 150H · Monroe, NCWas the pilot's failure to determine actual fuel consumption enroute. A factor was inadequate supervision by the instructor pilot.NTSB ATL92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Elizabeth City, NCInadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the soft terrain at the forced landing site.NTSB ATL87LA233Accident · No injuriesLimited investigationFinal reportCessna 150H · Lumberton, NCThe eng lost power and the plt attempted an off arpt landing. The acft nosed over during the landing roll. Records indicated that the acft had been refueled two days prior to the accident. Since that time it had been flown three and one tenth hours prior to…NTSB ATL84IA262Incident · No injuriesIncident investigationFinal reportCessna 150H · Gastonia, NCPlt reached charlotte, NC, and discovered he could not transmit on the acft radio. Plt diverted to gasotnia, NC, but could not locate the arpt because of lowering visibility. Plt flew around for a few minutes looking for identifiable landmarks. Precautionary…NTSB IAD76DKM46Accident · No injuriesClosedCessna 150 · Ashville, NCNTSB NYC71AN056Accident · 2 fatalClosedCessna 150H · Bahama, NCNTSB IAD70D0134Accident · No injuriesClosedCessna 150 · Swannanoa, NCNTSB DIA69D0172Accident · No injuriesClosedCessna 150G · Hillsboro, NCNTSB DIA68D0217Accident · No injuriesClosedCessna 150 · Fayetteville, NC