NTSB investigations: Cessna 150J, AL
9 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
| 1971 | 2 |
|---|---|
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2025 | 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\" = 'AL' 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" = 'AL' 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 ERA25LA225Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150J · Elberta, ALOn June 1, 2025, at about 1200 central daylight time, a Cessna 150J, N150FJ, was substantially damaged when it was involved in an accident near Elberta, Alabama. The pilot and the pilot- rated passenger were not injured. The airplane was operated under as a…NTSB MIA90FA163Accident · 2 fatalField investigationFinal reportCessna 150J · Baker Hill, ALAn inadvertent stall/spin. Factors were airspeed not maintained, altitude inadequate for safe recovery, and attention diverted.NTSB ATL88LA127Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Guntersville, ALThe seaplane collided with the water shortly after takeoff. The plt rptd that a large spider dropped in front of him and distracted him. The airplane was in a gradual right turn about 100 ft above the water at the time. He attempted to swat the spider with…NTSB ATL85LA117Accident · No injuriesLimited investigationFinal reportCessna 150J · Decatur, ALDuring eng start the acft accelerated into two parked acft causing substantial damage. The plt stated that the toe brakes were ineffective. Post crash investigation failed to disclose a preexisting failure or malfunction which may haverendered the brakes inop.NTSB MIA76DKJ01Accident · No injuriesClosedCessna 172H · Bessemer, ALNTSB MIA74FKJ55Accident · No injuriesClosedCessna 150 · Brewton, ALNTSB MIA74DKJ74Accident · No injuriesClosedCessna 150 · Ider, ALNTSB MIA71DKJ51Accident · Minor injuriesClosedCessna 150J · Huntsville, ALNTSB MIA71DKJ38Accident · No injuriesClosedCessna 150 · Midland City, AL