FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Accident 20080120014439ACessna U206F · Orlando, FL(-23) The aircraft departed runway 33 at the Kissimmee Gateway Airport for pattern work. On the crosswind to downwind turn the aircraft lost power, the pilot declared an emergency, tried to restart the aircraft with no luck, and was forced to make an off…Accident 20080120010451ACessna 172N · Corona, CA(-23) Mid air collision between CE-150 and CE-172. All four occupants killed, in addition to one person on ground fatally injured. (-23 amendment) midair collision between CE-150 and CE-72. Two occupants killed in each aircraft, in addition to one person on…Accident 20080120010352ACessna 150M · Corona, CA(-23) Midair collision between CE-150 and CE-172. All four occupants killed, in addition to one person on the ground fatally injured. (-23 amendment) midair collision between CE-150 and CE-172. Two occupants killed in each aircraft, in addition to one person…Incident 20080120010089IPiper PA28140 · Mesa, AZ(-23) N5024T, Piper PA-28-140, declared an emergency due to a fire shortly after departing rwy 22L, Falcon field, Mesa, AZ. Returned and landed on runway 4R at 1109 MST. ARFF responded and observed burned wire casings but no actual fire. The pilot stated…Incident 20080120009829IEpic Epiclt · Scottsdale, AZ(-23) Aircraft departed bismarck ND bound for carefree AZ. The enroute IFR flight was uneventful. The pilot cancelled IFR and entered the pattern at carefree skyranch (18AZ). On downwind the pilot extended gear but got no indicator lights. He then cycled the…Accident 20080119014339ACreelr SPORT2S · Arley, AL(-23) Preliminary: according to the pilot, at 35 feet above lewis smith lake, the pilot was preparing to roll N2669A out of a right turn onto a heading of 330 (downwind) when a "snap" was heard by the pilot. N2669A made an uncommanded increase in bank angle…Incident 20080119013499IBoeing 7472B4B · New York, NY(-23) Aircraft lined up with the rwy 31L right side rwy marking at kjfk airport. Upon take off it came in contact with eleven rwy side lights (2200') causing minor damage to the aircraft and destroying the 11 lights.Accident 20080119012539AAmtr Glastar · Vacaville, CA(-23) The owner requested that the pilot [privacy data omitted] charge the battery on his aircraft. A group of gentlemen helped start the aircraft by jumping the battery and [privacy data omitted] went along for the ride to the end of the runway to run the…Incident 20080119010549IPiper PA18A150 · Willows, CA(-23) At approx 1100HRS PST, N2415P, a Piper PA-18-A, lost engine power on short final to wlw's 34, and landed 1000 feet short of the rwy. No reported damage or injuries to the two occupants. Reporting ASI contacted NTSB iic (wp), "after phone interview with…Accident 20080119009689AAvianw Clipper · Green Valley, AZ(-23) Aircraft was reported missing on 1-19-08. On 1-20-08, aircraft was located approximately 3.5 miles northeast of ruby star airpark (14AZ). Aircraft was facing n, NE with a localized debris area with no damage to surrounding vegetation or skid marks…Incident 20080119000489IBoeing 737232 · Dillingham, AK(-23) On January 19, 2008, at about 2024GMT, a Boeing 737-200 airplane, N322DL, sustained minor damage to its left engine lower cowling when it hit several runway edge lights during landing at Dillingham Airport, Dillingham, Alaska. The airplane was being…Incident 20080119000319IPiper J3L65 · Garberville, CA(-23) Aircraft is certified as an experimental light sport aircraft (e-lsa). The engine was overhauled 02/22/1999 tach time 551.8. The engine failed in flight with 103.1 hours since major overhaul. The number one cylinder rod broke and caused a 2-inch hole in…Accident 20080119000229ALuscom 8E · Brigham City, UT(-23) The shock cords on the skis are in poor condition and weak. The shock cords are designed to keep the nose of the ski in a position to allow the trailing edge to contact the surface first. The pilot landed with the nose of the ski contacting the runway…Incident 20080118011669ICirrus SR20 · Milwaukee, WI(-23) The pilot [privacy data omitted] departed Milwaukee Timmerman airport (kmwc) on January 18th, 2008 at 2258 UTC in N952CD, a Cirrus-SR20 with a tow bar still attached to the nose wheel. The tow bar was drawn into the propeller and caused enough damage to…Incident 20080118010589ISwrngn SA227AC · Unalaska, AK(-23) On January 18, 2008, an airplane N41NE, SA-227 declared an emergency as a result of flight control failure. During taxiing in dutch harbor with 68 knots crosswind, the captain felt a "force" on the rudder. Pilot elected to taxi back. He visually…Accident 20080118009929APiper PA46500TP · San Antonio, TX(-23) On January 18, 2008, at approximately 12:40 local time, a Piper PA-46, registration N169CA piloted by [privacy data omitted] departed waco, Texas airport enroute to San Antonio, Texas airport. During the enroute to San Antonio airport, sat ATCT vectored…Incident 20080118009869ICndair CL6002B19 · Omaha, NE(-23) N841AY, CL600-2B19, being operated by pinnacle airlines as flight 5870 on a flight from detroit, mi to Omaha, NE, had flap failure on approach for landing. The crew declared an emergency and landed the aircraft safely. The crew reported that the flaps…Incident 20080118000589IBeech 35B33 · Yuma, AZ(-23) During touch and go landing, pilot inadvertently retracted the landing gear instead of the flaps on takeoff. He stated that the gear and flap handles are only about four inches apart, and he did not look before retracting what he thought were the flaps.…Incident 20080118000409ICessna T210L · Fallbrook, CA(-23) The pilot [privacy data omitted] (pilot-in-command) made several approach attempts but was either too fast or too high for each attempt. Airport manager got on the radio and suggested that the pilot make a slow 180 degree turn and land into the wind.…Accident 20080118000339ABeech V35B · Fresno, CA(-23) The aircraft was being operated on an IFR flight from Fresno chandler airport to san diego montgomery field by the owner/pilot. VFR conditions prevailed. The accident occurred approximately 8 miles and 9 minutes after takeoff. An ATC tape recording of…Incident 20080118000259IPiagio P180 · Beaumont, TX(-23) Crew on a repositioning flight from hobby airport (hou) to lexington, KY smelled what they described as electrical burning or arcing (no smoke or flames seen). They declared an emergency and landed at Beaumont, tex. (Bpt) without further incident.Incident 20080117832819ICessna 402C · Anchorage, AK(-23) After take-off from cordova the pilot retracted the landing gear and the nose gear green down and locked light remained illuminated. He cycled the gear several times but the nose gear light was continuously illuminated whether up or down. On landing at…Incident 20080117011719IBeech B300 · Bigfork, MN(-23) Part 91 flight originated from fcm with captain, fo, and 8 passengers on board. Normal operation and touch down runway 15 @ foz. Weather clear sunny, -20 deg f, no wind, runway surface icy with dusting of snow. Props taken out of reverse at approx 40…Accident 20080117009739APiper PA32301XTC · Angel Fire, NM(-23) At approximately 1625 MST on January 24, 2008, the pilot of N819C, a Piper PA-32-301XTC, aborted the landing roll midway down runway 35 at Angel Fire Airport (axx), Angel Fire, NM. As the aircraft departed, both main landing gear legs impacted the piled…Incident 20080117009659ICndair CL6002B19 · Lincoln, NE(-23) N820AY, CL600-2B19, being operated by pinnacle airlines as flight 2969 on a flight from detroit, mi to Lincoln, NE, had flap failure on approach for landing. The crew declared an emergency and landed the aircraft safely. The crew reported that the flaps…Accident 20080117000239AAmrgen AA5B · Norwood, MA(-23) The pilot [privacy data omitted] was cleared for take-off on runway 17 at approximately 1400 on 01/17/2008. Pilot's written and oral statements indicated take-off was normal until, in climb out at approximately 200' AGL, while in left turn to clear…Accident 20080116844429ABeech 58 · Cleveland, OH(-23) On January 16, 2008, approximately 1922 local eastern standard time (0022 zulu), N3217L, a Hawker Beechcraft corporation BE-58 airplane, piloted by an airline transport pilot, sustained substantial damage on impact with lake erie during its climb after…Accident 20080116010449AGulstm 500B · Tulsa, OK(-23) Aircraft departed Tulsa international (tul) airport at 2240HRS CST enroute to wiley post (pwa). After departure tul tower called pilot and he reported a gyro problem. Tower gave the pilot a left turn heading 250 degrees, with an assigned altitude of…Accident 20080116010369ABeech 58P · Hereford, TX(-23) On January 16, 2008 at approximately 1430 CST, N42SM, a Beech 58P, during the part 91 flight from texarkana, Texas (tkx) to phoenix, Arizona (phx), struck the right wing on landing while attempting a visual approach to the Hereford, Texas (hrx) airport…Incident 20080116010259ICirrus SR20 · Battle Creek, MI(-23) ATC control tower requested aircraft to land as short as possible at threshold due to another aircraft landing midway down 10000 ft runway. Aircraft wheel struck runway end light.Accident 20080116009939ACessna 207 · Aniak, AK(-23) While enroute to Aniak, AK from crooked creek, AK, the pilot reported losing engine power and crash landed on the river about a mile from the airport at Aniak, AK in white out conditions.Incident 20080115832709IStbros SD330 · Kenosha, WI(-23) The pilot stated she was on a scheduled check ride. Prior to departure the aircraft logbook was checked with two aircraft discrepancies noted, and cleared by maintenance. (1. The aircraft pulled uncontrollably to the left. This discrepancy was cleared…Incident 20080115013389ICessna 182T · Cartersville, GA(-23) On approach to landing to runway 01 at the Cartersville, GA (kvpc) airport during the landing phase the pilot of N6197Z lost control of the aircraft during a crosswind landing. Reported winds at kvpc were reported as gusty from approximately 320-350…Accident 20080115010999ACessna 208B · Bethel, AK(-23) The pilot landed at the Bethel, Alaska airport between runway 18 and the taxiway. The aircraft touched down on the tundra collapsing the nose gear, coming to rest on taxiway delta. The aircraft sustained damage to the propeller, cargo pod, nose gear and…Accident 20080115009899ARobsin R44RAVENII · Fenner, NY(-23) N122AA was returning to syracuse, NY on a special VFR flight plan. The pilot experienced poor visibility due to blowing snow and winds. The pilot spiraled down, set the helicopter down in a field, landing hard. The skids separated from the fuselage, the…Incident 20080115000609IHughes 269C · Carlsbad, CA(-23) 1) Helicopter departed palomar airport (crq) for a training flight to oceanside airport (ocn). On return flight back to crq, emergency low level light illuminated and the helicopter made a landing on the beach. The instructor called the home base, a…Incident 20080115000459ICessna 402CESSNA · Calexico, CA(-23) The reporting inspector conducted an interview with the pilot on 01/23/08. The pilot stated that he was relocating the aircraft from san felipe, bc to oceanside, CA on the day of the incident. The pilot stated that he needed to land at Calexico, CA for…Accident 20080114014349APiper PA32260 · Atlanta, GA(-23) During a landing to runway 20R at the Dekalb-Peachtree Airport on Monday, January 14, 2008 at approximately 05:19Z, N3528W, a Piper PA-32-260, piloted by [privacy data omitted] left the runway paved surface, striking a taxiway sign and a runway edge…Incident 20080114011989IPiper PA31350 · Kaunakakai, HI(-23) Failure of connecting rod bolt, connecting rod assembly and puncture of crankcase. Loss of power in left engine.Incident 20080114011519IBeech 3533 · Carlsbad, CA(-23) During third landing, student lowered flaps instead of gear. Ip was looking for traffic that the tower called. Ip stated he heard flying pilot state "gear down" same as other two landings. Ip looked at gear indicator for verification, sun was shining on…Incident 20080114010819IMooney M20J · Casa Grande, AZ(-23) Pilot reported that he performed extended engine run up prior to take off. After departing runway 5 and climbing through 150 feet above ground level the aircraft experienced a sudden loss of power from the engine. The pilot reported he declared an…Accident 20080114009669ABeech 1900C · Kauai, HI(-23) The aircaft was conducting on demand cargo IFR under 14 CFR part 135. Radar shows the aircraft flying into the ocean approximately 7 miles from the airport for reasons unknown. Limited amounts of aircraft wreckage were recovered. The main body of the…Incident 20080114000579IMooney M20C · Tupelo, MS(-23) On 1/14/2008, N6720U, Mooney 20 aircraft landed at Tupelo, MS (tup) approximately 1620 local time. Upon exiting the runway onto the taxiway the aircraft ran off the taxiway into the grass. The pilot stated his foot slipped off the rudder pedal. The…Incident 20080113832939IGulstm G1159 · Chicago, IL(-23) While taxiing to parking spot, N747NB taxied into trailing edge of parked Cessna 208. PIC stated that there was only one marshaller at the front of the aircraft and that lights from awaiting secret service vehicles were in his eyes. There was a fueler…Accident 20080113009979AJabiru JABIRUJ400 · Santa Monica, CA(-23) The aircraft touched down on runway 21 with approximately 3000' of runway remaining. During the landing roll the aircraft suffered a brake system failure and the airman was unable to stop the aircraft on the runway surface. As noted in the initial…Incident 20080113009639IMooney M20F · Monroe, LA(-23) Pilot experienced complete electrical failure approximately 50-60 miles from destination. Upon reaching destination the electric gear system was inop. Pilot manually cranked the gear down, made a pass by the tower to confirm 3 gear down, and then…Incident 20080113000549IBeech 77 · Half Moon Bay, CA(-23) The student pilot was attempting to accomplish a touch-and-go on runway 30. Winds were light and variable. After touchdown, the pilot reset the wing flaps, applied power to the aircraft, and lost directional control. The aircraft departed the runway's…Accident 20080113000361ACndair CL6002C10 · San Francisco, CA(-23) On January 13, 2008 at San Francisco International Airport, approximately 1932 hrs PST two aircraft backed into each other during push back. The united airlines (ual) Boeing 757-222 aircraft, registration number N508UA, serial number 24744 was being…Accident 20080113000352ABoeing 757222 · San Francisco, CA(-23) On January 13, 2008 at San Francisco International Airport, approximately 1932 hrs PST two aircraft backed into each other during push back. The united airlines (ual) Boeing 757-222 aircraft, registration number N508UA, serial number 24744 was being…Accident 20080113000199APiper PA12 · Centerville, WA(-23) On January 13, 2008 the pilot and one passenger departed a private runway (9WA4) and flew to the dalles, airport (kdls) for fuel. After fueling the left and right hand fuel tanks they departed and flew sight seeing and photography flights for…