NTSB investigations, AL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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' 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 MIA08CA076Accident · 1 fatalData collectionFinal reportBeech C24R · Mobile, ALUndetermined.NTSB ATL82DA071Accident · Minor injuriesFinal reportBeech B24R · Pell City, ALWhile the pilot was making touch and go landings, the engine lost power as the aircraft was climbing through about 300 ft AGL. The pilot landed in a field with the landing gear up to reduce the stopping distance. No pre- impact malfunctions or failures were…NTSB ATL82DA063Accident · Minor injuriesFinal reportSmith Mini · Brownsboro, ALThe pilot took off with a malfunctioning fuel quantity guage. Before takeoff, he visually checked the fuel and estimated that the tank was about 1/2 full. After returning from a local flight, the engine lost power during a turn to final approach for landing.…NTSB ATL82FA057Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hytop, ALThe pilot filed and departed VFR into forecast marginal flight conditions. While en route the destination went IFR and this information was passed on to the pilot. The pilot replied that he was going to continue on and get as close to chattanooga as possible.…NTSB ATL82IA051Incident · No injuriesIncident investigationFinal reportBeech 200 · Birmingham, ALWhile climbing thru 500 ft AGL on takeoff, the manual pitch trim struck at 1 or 2 units nose up. Use of the three trim disconnect switches did not remedy the problem. About 30 secs later, the pitch trim ran away nose up and would not stop until the pitch trim…NTSB ATL82DA046Accident · Serious injuriesFinal reportCessna T210L · Luverne, ALThe engine abruptly quit during takeoff after the pilot reduced power and started a crosswind turn. The nose gear collapsed rearward during landing roll in a soft terraced pasture and the aircraft flipped to an inverted position. Two ounces of water were…NTSB ATL82FKJ11Accident · Serious injuriesFinal reportPiper PA-32 · Muscle Shoals, ALDuring the approach the pilot stated that he could not extend the landing gear. At some point during the approach the aircraft broke out into VFR conditions. The pilot stated he had the airport in sight when the aircraft struck a 160,000 volt power line.…NTSB ATL82FA037Accident · 4 fatalField investigationFinal reportCessna 210L · Madison County, ALThe aircraft departed destin, FL at 1554 CST on a flight to tullahoma, TN. The estimated time en route was listed on the flight plan as 2.5 hrs with 4.5 hours fuel on board. During arrival at tullahoma, the pilot initiated a vor/dme-b approach, but executed a…NTSB ATL82DA036Accident · No injuriesFinal reportBell 206B · Centerville, ALThe mishap occurred during a practice hover with a 100 ft cable in preparation for an external load operation. While hovering about 100 ft AGL, the fuel boost pump light illuminated and the boost pump pressure dropped to zero. A descent was started; however,…NTSB ATL82DKJ09Accident · No injuriesFinal reportCessna 310L · Auburn, ALThe pilot tookoff from north huntsville on a runway that was wet from melted snow. After takeoff, the gear would not retract, so he returned and landed. A mechanic found ice on the anti-retraction switch on the left main gear. A ground heater was used to melt…NTSB ATL82DKJ10Accident · No injuriesFinal reportBeech V35B · Tuskegee, ALDuring landing, the pilot put the landing gear and flap handles in the down positions. He heard noises that sounded like both had extended and assumed everything was in place. The pilot was unaware that the landing gear was not down until after touchdown. An…NTSB ATL82FKJ08Accident · No injuriesClosedCessna 152 · Phenix City, ALNTSB ATL82FKJ07Accident · No injuriesClosedCessna 150 · Birmingham, ALNTSB ATL82FKJ06Accident · Serious injuriesClosedCessna 150 · Russellville, ALNTSB ATL82FKJ04Accident · No injuriesClosedCessna 172M · Selma, ALNTSB ATL82DKJ03Accident · No injuriesClosedCessna T210N · Bayou La Batre, ALNTSB ATL82FKJ05Accident · No injuriesClosedBeech 3NM · Ohatchee, ALNTSB ATL82FA011Accident · No injuriesClosedBeech 58 · Selma, ALNTSB ATL82DKJ01Accident · No injuriesClosedPiper PA-28 · Dothan, ALNTSB ATL82DKJ02Accident · No injuriesClosedPiper PA-28 · Hurtsboro, ALNTSB ATL82FA001Accident · 2 fatalClosedPiper PA-38 · Gadsden, ALNTSB ATL81DKJ37Accident · No injuriesClosedCessna 182 · Elberta, ALNTSB ATL81FKJ36Accident · Minor injuriesClosedAir & Space 18A · Huntsville, ALNTSB ATL81FA116Accident · 2 fatalClosedPiper PA-38 · Cullman, ALNTSB ATL81FKJ35Accident · No injuriesClosedBellanca 14-19 · Weaver, ALNTSB ATL81DA113Incident · No injuriesClosedBoeing 727 · Birmingham, ALNTSB ATL81FKJ34Accident · No injuriesClosedCessna 172 · Bay Minette, ALNTSB ATL81DKJ33Accident · Minor injuriesClosedPiper PA-28 · Brundidge, ALNTSB ATL81DKJ32Accident · Serious injuriesClosedPiper PA-32 · Tuscaloosa, ALNTSB ATL81DKJ31Accident · Minor injuriesClosedCessna 150 · Huntsville, ALNTSB ATL81DKJ30Accident · No injuriesClosedCessna 150M · Hamilton, ALNTSB ATL81DKJ29Accident · No injuriesClosedCessna 172N · Daviston, ALNTSB ATL81DKJ28Accident · No injuriesClosedPiper PA-32 · Butler, ALNTSB ATL81FKJ27Accident · No injuriesClosedAyres S2R · Ft Mitchel, ALNTSB ATL81DKJ26Accident · No injuriesClosedPiper PA-28 · Bessemer, ALNTSB ATL81FA101Accident · 4 fatalClosedCessna 210B · Plantersville, ALNTSB ATL81FKJ25Accident · Serious injuriesClosedCessna 177B · Wetumpka, ALNTSB ATL81FKJ23Accident · No injuriesClosedStinson 108-2 · Huntsville, ALNTSB ATL81FKJ24Accident · 1 fatalClosedPiper J3C-65 · Fadette, ALNTSB ATL81DKJ22Accident · No injuriesClosedHiller Acft UH-12E · Centreville, ALNTSB ATL81FA090Accident · 2 fatalClosedCessna 182M · Haleyville, ALNTSB ATL81FKJ38Accident · Serious injuriesClosedCessna U206 · Elberta, ALNTSB ATL81FA083Accident · 2 fatalClosedPiper PA-38 · Smiths Station, ALNTSB ATL81FKJ21Accident · No injuriesClosedCessna 182RG · Gadsden, ALNTSB ATL81DKJ20Accident · No injuriesClosedCessna 152 · Huntsville, ALNTSB ATL81FA067Accident · No injuriesClosedAdams A50S · Montevallo, ALNTSB ATL81IA065Incident · No injuriesClosedCessna 414 · Montgomery, ALNTSB ATL81DKJ17Accident · Minor injuriesClosedCessna 172 · Maysville, ALNTSB ATL81FKJ16Accident · No injuriesClosedCessna 150 · Ozark, ALNTSB ATL81DKJ14Accident · No injuriesClosedPiper PA-38 · Auburn, AL