NTSB investigations: Cessna 150J, TN
8 cases on aircraft the registry lists as Cessna 150J. 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
| 1969 | 2 |
|---|---|
| 1970 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 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\" = '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 ('2071820'))
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 ('2071820'))
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 ATL91FA025Accident · 1 fatalField investigationFinal reportCessna 150J · Ripley, TNPerforming a stall maneuver at an altitude below prescribed minimums, and his failure to apply correct flight control inputs to recover from the stall and spin.NTSB ATL88FA106Accident · 2 fatalField investigationFinal reportCessna 150 · Knoxville, TNThe Cessna made a long straight in final approach. The aircraft's radio transmitter was inop. Afterward the Cessna PIC rpted that initially he saw the Beech on a left base. Later he stated the Beech was heading away from the traffic pattern. Witnesses…NTSB ATL87LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Waverly, TNThe plt reported that he was taxiing to the rwy when the 'rudder failed to turn the (airplane) onto the rwy and the left brake failed.' The airplane subsequently ran off the end of the taxiway, traveled approx. 50 ft., went over a steep dropoff and collided…NTSB IAD79FLT01Accident · No injuriesClosedCessna 150 · Covington, TNNTSB IAD75AI024Accident · 1 fatalClosedCessna 150 · Johnson City, TNNTSB MIA70FKW03Accident · Minor injuriesClosedCessna 150J · College Grve, TNNTSB MIA70D0270Accident · Minor injuriesClosedCessna 150 · Spring City, TNNTSB MIA70D0061Accident · No injuriesClosedCessna 150 · Lobelville, TN