NTSB investigations, AL
16 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 4 |
| 1993 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
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" = 310) 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 MIA08CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Tuscaloosa, ALThe pilot's failure to maintain a visual look out while taxing resulting in an on-ground collision with a parked airplane.NTSB ATL03LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fayette, ALThe pilot's poor inflight decision to land on a non illuminated runway, and the pilot's failure to maintain clearance during an attempted night landing that resulted in an on ground collision with a parked car. A factor was the light condition.NTSB ATL02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bessemer, ALOn ground collision with an animal during landing.NTSB ATL01FA021Accident · Serious injuriesField investigationFinal reportLearjet LJ-60 · Troy, ALOn ground collision with deer during landing roll, and the inadvertent thrust reverser stowage caused by the damage to the landing gear squat switch by the collision, and subsequent application of forward thrust during rollout.NTSB ATL94LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Autaugaville, ALThe pilot's inadequate preflight planning, in that he did not properly evaluate the condition of the runway prior to takeoff, and his failure to abort the takeoff when adequate acceleration was not observed. Factors were the high vegetation (grass) on the…NTSB ATL93LA101Accident · No injuriesLimited investigationFinal reportCessna 150H · Lafayette, ALThe pilot's failure to maintain adequate clearance from the mile marker sign during the takeoff roll. A factor was the sign adjacent to the highwayNTSB DCA85AA026Accident · 1 fatalFinal reportBeech E18S · Birmingham, ALAt 2045 the military flt, dixie 06, contacted Birmingham apch & obtained clearance for a low apch followed by a full-stop lndg on rwy 05. At 2053, dixie 06 reported a 4 mile final for a low apch to the local controller. At 2054:19, the local controller…NTSB ATL85FA169Accident · No injuriesField investigationFinal reportLuscombe 8-A · Columbiana, ALThe airstrip is used primarily as a gliderport and at the time of the accident, traffic was being controlled by a person on the ground using handsignals. N28428 proceeded on to the rwy to takeoff as the ultralight was on final apch. Both plts observed the…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 ATL85LA108Accident · No injuriesLimited investigationFinal reportCessna 172H · Bessemer, ALThe plt was taxiing to the rwy on a narrow taxiway when the left wing struck a t hangar support post.NTSB ATL84LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Boaz, ALThe acft collided with a traffic sign while taxiing for takeoff on a highway. The plt said he was a'path finder' for a fly-in and had the cooperation of the police. The owner of the acft said the plt was not authorized to use the acft for this flt.NTSB ATL84LA047Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Bessemer, ALThe acft collided with a station wagon while taxiing for takeoff during a purchaser demonstration flt. The prospective buyers were a husband and wife and the wife was occupying the left front seat with the CFI in the right seat. The CFI stated, that while…NTSB ATL84IA029Incident · No injuriesIncident investigationFinal reportCessna 150M · Mobile, ALThe acft collided with a light pole while taxiing. The instructor pilot was preoccupied with locating a tie down spot.NTSB ATL83FU001Accident · No injuriesFinal reportWizard J-3 · Wetumpka, ALThe plt reported having about 0.4 hour of experience in this new ultralight vehicle. The nosewheel of the vehicle was not steerable & there were no brakes on the main gear. Therefore, the plt relied on the rudder for ground steering. At slow speed, air from…NTSB ATL82DA240Accident · Minor injuriesFinal reportCessna 180 · Grand Bay, ALReportedly, the pilot was preparing to fly the aircraft, but the battery was dead, so he hand propped the engine to start it. According to the pilot's father, the aircraft was left unattended with the engine operating at idle speed. The pilot reported that he…NTSB ATL82DA205Accident · No injuriesFinal reportBeech J35 · Birmingham, ALThe pilot reported that he had received an instrument clearance before starting the engine and noted that the battery was weak. He reported that he decided to pull the propeller through and turned the ignition switch toward the off position. As the propeller…