NTSB investigations, AL
57 cases where the first occurrence was “Loss of control - on ground/water”.
Cases, newest first
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 ATL83LA375Accident · No injuriesLimited investigationFinal reportBeech 77 · Montgomery, ALThe student plt flew to Montgomery, AL, intending to make a touch-and-go landing, and then return to birmingham, AL. After arriving, he made an apch to rwy 09 with a wind from 360 deg at 10 gusting 14 KTS. While on the landing roll, the acft began to veer to…NTSB ATL83LA343Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 600-A · Florala, ALThe pilot stated that during takeoff roll he experienced a power surge but the engine did not quit. He aborted the takeoff by reducing power on both engines and applying brakes. This resulted in the aircraft swerving off the right side of the runway, rolling…NTSB ATL83LA276Accident · No injuriesLimited investigationFinal reportPiper L-21B · Vernon, ALThe acft departed the rwy & nosed over inverted during an unauthorized flight. After the accident the non-certificated plt told the owner that he had flown the acft several times based on the permission of a friend who was authorized to fly the acft.NTSB ATL83LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · Jasper, ALAs the acft was taxiing on rwy 9 for a takeoff on rwy 27 the left main gear dropped off the rwy into soft terrain. The plt attempted to taxi back onto the rwy by turning the nose gear to get a better edge. Nevertheless, both the nose &left gear left the rwy &…NTSB ATL83LA101Accident · No injuriesLimited investigationFinal reportBeech H18 · Talladega, ALThe plt stated that shortly after full power application & prior to tailwheel lift-off, the 'right wing raised aprx 3 to 4 ft into the air.' The acft then began drifting left. During ensuing maneuvers, the plt alternately advanced & retarded the throttle as…NTSB ATL82DA271Accident · No injuriesFinal reportGrumman AA-5B · Moulton, ALAccording to the pilot, after touchdown he applied brakes and the right brake seemed to lock intermittently during the roll out. Black marks on the landing surface reveal the aircraft departed the right side and impacted an embankment and steel post. This was…NTSB ATL82DA099Accident · No injuriesFinal reportPiper PA-28-140 · Huntsville, ALShortly after a normal touchdown the aircraft yawed and veered to the left. The pilot elected to go-around and added full power. The aircraft departed the left side of the runway and collided with a barbed wire fence. The aircraft settled into a plowed field…