NTSB investigations: Cessna 150F, TN
17 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 | 2 |
|---|---|
| 1967 | 2 |
| 1968 | 2 |
| 1971 | 2 |
| 1972 | 2 |
| 1979 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1996 | 1 |
| 2010 | 1 |
| 2024 | 2 |
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\" = 'TN' 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" = 'TN' 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 ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.NTSB ERA24LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Fayetteville, TNA collision with a deer during the takeoff roll.NTSB ERA10FA503Accident · 1 fatalField investigationFinal reportCessna 150F · Sweetwater, TNThe pilot's inadequate preflight weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB MIA97LA006Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Lexington, TNfailure of the pilot to abort the takeoff after encountering excessive ground roll, and failure (or inability) of the pilot to obtain/maintain adequate airspeed, which resulted in an inadvertent stall. Factors relating to the accident were: restricted…NTSB ATL85LA088Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Hartford, TNThe plt was informed during wx briefing that VFR was not recommended because of low clouds. Plt elected to takeoff and follow I-90, however, wx conditions were poor and plt executed a climb to 10000 ft to clear the cloud layer. While en route the plt tuned to…NTSB ATL81FKW12Accident · No injuriesClosedCessna 150F · Lebanon, TNNTSB IAD79FKW06Accident · 2 fatalClosedCessna 150F · Bristol, TNNTSB MIA73FLT05Accident · No injuriesClosedCessna 150F · Memphis, TNNTSB MIA72FLT12Accident · Serious injuriesClosedCessna 150 · Yorkville, TNNTSB MIA71FLT16Accident · Minor injuriesClosedCessna 150 · Memphis, TNNTSB MIA71FLT14Accident · Serious injuriesClosedCessna 150 · Memphis, TNNTSB MIA68D0550Accident · No injuriesClosedCessna 150 · Tellico Plns, TNNTSB MIA68D0539Accident · No injuriesClosedCessna 150 · Gallatin, TNNTSB MIA68D006UAccident · No injuriesClosedCessna 150 · Lawrenceburg, TNNTSB MIA67F0574Accident · No injuriesClosedCessna 150 · Springfield, TNNTSB MIA67F0277Accident · No injuriesClosedCessna 150 · Somerville, TNNTSB MIA67F0219Accident · No injuriesClosedCessna 150 · Ashland City, TN