NTSB investigations: Cessna 150, GA
15 cases on aircraft the registry lists as Cessna 150. 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
| 1965 | 2 |
|---|---|
| 1967 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1981 | 2 |
| 2001 | 1 |
| 2007 | 1 |
| 2023 | 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\" = 'GA' 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 ('2071802'))
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" = 'GA' 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 ('2071802'))
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 ERA24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Atlanta, GAThe flight instructor’s inadequate remedial action and the student pilot’s failure to relinquish the flight controls as directed by the flight instructor, resulting in a loss of control and nose over.NTSB ATL07CA039Accident · No injuriesData collectionFinal reportCessna C150 · Palmetto, GAThe pilot's inadequate compensation for a crosswind during the landing flare, which resulted in a loss of control and an in-flight collision with objects. A factor associated with the accident was a crosswind.NTSB ATL01LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAThe pilot's inadequate preflight fuel planning for the flight that resulted in the fuel exhaustion and the subsequent loss of engine power.NTSB ATL81FKG19Accident · No injuriesClosedCessna 150 · Williamson, GANTSB ATL81DKG14Accident · No injuriesClosedCessna 150 · Oglethorpe, GANTSB MIA78FKG70Accident · No injuriesClosedCessna 150 · Savannah, GANTSB MIA78DLA07Accident · Minor injuriesClosedCessna 150 · Whigham, GANTSB MIA77DLA45Accident · No injuriesClosedCessna 150 · Nashville, GANTSB MIA75FKG13Accident · Serious injuriesClosedCessna 150 · Stockbridge, GANTSB MIA72DKH22Accident · No injuriesClosedCessna 150 · Glynco, GANTSB MIA71FKG89Accident · No injuriesClosedCessna 150J · Lithonia, GANTSB MIA70F0300Accident · No injuriesClosedCessna 150H · Kennesaw, GANTSB MIA67D0507Accident · No injuriesClosedCessna 150 · Mcdonough, GANTSB MIA66A0032Accident · 2 fatalClosedCessna 150 · Resaca, GANTSB UNK65X1418Accident · No injuriesClosedCessna 150 · Buford, GA