NTSB investigations, GA
19 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1985 | 1 |
|---|---|
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 3 |
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\" = 'GA' 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\" = 430)
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" = 'GA' 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" = 430) 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 MIA07CA119Accident · Serious injuriesData collectionFinal reportBoeing 777-232 · Atlanta, GAThe flight attendant's inadvertent misstep on a ladder and falling during pushback resulting in serious injuries.NTSB ATL07IA078Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Atlanta, GAThe mechanics failure to follow procedures and directives in securing the lower engine cowling after maintenance, and the failure of the first officer to follow the checklist to ensure the engine cowling was secured during the walk around inspection resulting…NTSB OPS07IA002Incident · No injuriesIncident investigationFinal reportBoeing 757-212 · Atlanta, GAThis incident was caused by the local controller's issuance of an improper takeoff clearance to DAL1606. Contributing was the failure of the oncoming and outgoing local controllers to provide and receive a complete position relief briefing; and the oncoming…NTSB ATL05CA131Accident · No injuriesData collectionFinal reportCessna 525A · Newnan, GAThe pilot's delay in aborting the landing and his failure to maintain obstacle clearance. Contributing factors were hydroplaning condition, and the localizer antenna.NTSB ATL04IA156Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-233 · Atlanta, GAThe failure of company maintenance personnel to secure the nacelle/cowl doors, which resulted in a separation of the doors during takeoff initial climb.NTSB ATL03FA136Accident · 1 fatalField investigationFinal reportBeech BE-55 · Winder, GAThe pilot's inadequate preflight preparation in which he failed to secure the cabin door which diverted his attention and resulted in the failure to maintain directional control.NTSB MIA01LA215Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Savannah, GAThe delay of the pilot to perform a go-around following a bounced landing and porpoise, and failure of the pilot to maintain directional control resulting in the airplane departing the runway and colliding with a berm.NTSB MIA01FA119Accident · 1 fatalField investigationFinal reportBeech A-45/T-34A · Claxton, GAThe pilot in command's failure to maintain airspeed while performing an emergency landing after having just taken off with an unsecured fuel cap, which resulted in an inadvertent stall mush, an uncontrolled descent, and an impact with trees.NTSB MIA00LA174Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Milledgeville, GAThe operation of the airplane by the pilot-in-command in an over gross weight condition, the failure of the pilot to maintain airspeed (Vs) after takeoff, and the intentional stalling of the airplane by the pilot-in-command for his attempting to bank while…NTSB MIA98LA161Accident · No injuriesLimited investigationFinal reportRevolution MINI-500 · Villa Rica, GAThe pilot's choice of landing area during a precautionary landing adjacent to the runway. This resulted in an in-flight collision of the left skid with a rock during a cyclic flare, loss of directional control, and subsequent collision of the main rotor blade…NTSB MIA98FA047Accident · 2 fatalField investigationFinal reportCessna 414A · Guyton, GAInadequate maintenance of the cabin pressurization system, which resulted in inadequate pressurization and incapacitation of the pilot due to the hypoxia. Also causal was the pilot's failure to adequately monitor the cabin pressurization system.NTSB ATL97IA061Incident · No injuriesIncident investigationFinal reportBritish Aerospace 125-800A · Chamblee, GAphysical impairmant of the captain during flight, which was the resulted of a kidney stone.NTSB ATL97IA042Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Atlanta, GAfailure of ground service personnel to properly close the aft cargo door before the airplane departed.NTSB ATL93LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Atlanta, GAThe inadequate procedures and training of ground personnel involved in the aircraft push back operations by company management.NTSB ATL89IA057Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Atlanta, GA1St officer was observed to be sick & was replaced on the flt prior to departing the originating city. Subsequently, he was confronted by an intervention group regarding his condition and requested medical assistance under the company employee assistance…NTSB ATL87FA255Accident · Serious injuriesField investigationFinal reportCessna 402C · Atlanta, GADuring climb to cruise at about 4,000 ft MSL, the plt heard a 'whistling' noise and noticed that the crew door adjacent to his seat was not completely secured. The door came open as he attempted to properly secure it, and yanked his left arm outside the acft.…NTSB ATL86IA190Incident · Minor injuriesIncident investigationFinal reportSwearingen SA-26AT · Waycross, GAThe pax had received instructions by the plt on how to open the cabin door. The acft was shut down on the ramp and the pax attempted to open the cabin door. The latch was turned; the door began to fall open and the pax caught the door step channel at a hinge…NTSB ATL86LA165Accident · No injuriesLimited investigationFinal reportCessna 172M · Cobb, GAThe plt reported a rough running eng. He attempted a precautionary ldg during which the acft's nose wheel dug in the soft ground and the acft nosed over. Post accident inspection of the eng failed to disclose any failures/malfunction.NTSB ATL86FA014Accident · Serious injuriesField investigationFinal reportPiper PA-34-220T · Ocilla, GAThe pilot of the second company aircraft to arrive in the vicinity of the airport held while the first attempted an ndr approach. After the first aircraft made a missed approach the pilot of the second aircraft attempted the approach. The aircraft flew into…