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.
Incident 20040424006849IMooney M20J · Cincinnati, OH(-23) Aircraft was landed gear-up on RW-3R at kluk and aircraft skidded to a stop on center line of runway. Pilot stated he forgot to extend the landing gear before landing, due to not using the landing check list properly. Pilot also stated he couldn't…Incident 20040424006739ICessna 152 · Akron, OH(-23) Upon being cleared for a touch and go the pilot stated that the aircraft hit the runway and bounced back up, then the pilot hit the runway again very hard. The nosewheel separated the aircraft on the last bounce, the aircraft skid to a stop on the…Accident 20040424006199ABbavia 7AC · Flushing, MI(-23) Attempting a crosswind landing to runway 09. The aircraft was put into a slip, stalled and landed hard on runway 09.Incident 20040424006029ICessna T210M · Visalia, CA(-23) The pilot and instructor were participating in flight training for the "wings program". After completing a landing at the Visalia airport, a departure was made for left traffic and another landing on runway 30. While on downwind and on final, the…Incident 20040424005809ICessna 210C · Salem, OR(-23) During landing phase the landing gear failed to extend fully, pilot attempted to hand pump the gear down but was unable. Pilot landed the aircraft with the main gear in transit and nose down and locked. The aircraft incurred damage to the main gear…Accident 20040423034129AAmtr Lancairlegay · Oakland, TN(-23) Aircraft impacted into the ground at a nose down attitude - aircraft destroyed. Debris field stretched approximately 25-30 yards on both sides of impact site and 75 yards south of site. No signs of wing or prop impact marks at the scene. Pieces of both…Accident 20040423007409APiper PA28R200 · Atkinson, NC(-23) On April 24 at approximately 0043Z a Piper pa 28R-200 aircraft called a "mayday" on the wilmington (ilm) approach control frequency. The aircraft stated it was having an engine problem. Within 3 minutes the aircraft made an off-airport landing in a…Incident 20040423007339IBeech 1900D · Farmington, NM(-23) On April 23, 2004, at 1515 CST, a Beech BE-1900-D, N135YV, registered to mesa airlines, inc., (air midwest, flight no. 4000) declared an emergency on approach for landing at Farmington, NM (fmn). The aircraft made a go around due to an unsafe landing…Accident 20040423005999ACessna 170B · Nampa, ID(-23) Pilot in command, allowed another pilot to make a landing in his aircraft. The pilot touched down on the runway and lost directional control. The aircraft departed the runway and went over on its back causing substantial damage. All control systems…Incident 20040422009909INortrp N9MB · Chino, CA(-23) N9MB, the northrop flying wing, reported a rough running engine prior to landing at Chino, CA without further incident at 221326PDT.Accident 20040422009679ACessna 182P · San Antonio, TX(-23) On April 22, 2004, at 1600 central daylight time, N7435Q, a Cessna 182P single-engine airplane, registered to whilybird inc., and operated by Mr. William david lowell, was substantially damaged when the right wing tip struck a road grader vehicle during…Incident 20040422008819IBeech 1900D · Dallas-Ft Worth, TX(-23) On April 22, 2004, at 2309, air midwest 2629 (AMW2629) departed runway one three left at Dallas/ft. Worth airport (kdfw) bound for the texarkana propeller departure gate (txp). At 2310, AMW2629 reported to the local east 17 controller (LE17) the need to…Accident 20040422008749APiper PA18150 · Minneapolis, MN(-23) Pilot changed fuel selector just prior to takeoff after doing runup. Fuel was interrupted either by being placed in the off position or in between tanks. Unable to determine since pilot says he changed the fuel selector after takeoff as part of an…Incident 20040422008229ICessna 172M · Allentown, PA(-23) Pilot was landing at Lehigh Valley International Airport (abe) on runway 6. Pilot landed hard, causing damage to nose wheel and propeller.Accident 20040422006429ARobsin R22BETA · Long Beach, CA(-23) On April 22, 2004, at 1621 PDT, Robinson, R-22 beta, N8492A, was hovering on pad #1 at lgb airport facing approximately 270 degrees. The winds at the time were 300 at 16 knots. The pilot initiated a left pedal turn and lost control of the helicopter.…Accident 20040422006389AArctic S1B2 · Willow, AK(-23) First instructional flight for student pilot. During simulated engine failure recovery, engine failed to respond. No suitable landing area available within gliding distance. Instructor flew aircraft into trees to avoid a building. Both occupants…Incident 20040422005889ICessna 414A · Casper, WY(-23) During climbout from Casper, WY the left engine started to run rough and the pilot returned to the airport for landing. Aircraft landed without further problems. The left engine was not shut down or propeller feathered during flight. Post flight…Incident 20040422005789IMooney M20B · Everett, WA(-23) Previously N74545 experienced mechanical failure and the gear collapsed while taxiing clear of the runway on September 30, 2003. Waiting for repairs to his aircraft, the pilot had only flown approximately one hour within the 6 months prior to this…Accident 20040421025969APiper PA34220T · Willoughby, OH(-23) On April 21, 2004 pilot made a hard landing due to bad weather (wind shear). Damage was substantial. No injuries.Accident 20040421018309AAirtrc AT502B · San Angelo, TX(-23) On April 21, 2004, approximately 1230 CST, N5196J, an air tractor 502B single-engine airplane, was destroyed by fire after it collided with terrain during takeoff from powell ranch near San Angelo, Texas. The pilot attempted to takeoff from a…Incident 20040421014949IDoug MD9030 · Salt Lake City, UT(-23) Flight crew of of aircraft thought aircraft right hydraulic system became disabled because the hydraulic pressure and quantity indicators (EFIS) read "----". Flight crew shut down right hydraulic system and declared an emergency landing to destination…Incident 20040421010889IBag JETSTM3101 · Lufkin, TX(-23) L/h tire blew out upon landing at lfk rwy 7 resulting in some minor damage to the aircraft. Broken landing gear door rod, cut hyd line and minor damage to the fuselage.Incident 20040421009939IPiper PA32R300 · Baco Raton, FL(-23) On 04/21/04 at approx. 1800 hours local Mr. Edward swakon landed his Piper PA-32R-300 N5548V at Boca Raton Airport runway 5 with the landing gear up. Mr. Swakon stated the flight was from fort lauderdale intl (fll) to Boca Raton arpt (bct) and the hand…Accident 20040421008179AHynes B2B · Wichita Falls, TX(-23) On April 21, 2004, at 1045 central daylight time, a brantly B-2B helicopter, N9030Z, owned by brantly international incorporated, crashed. The helicopter was operated by kevin Hynes who was providing flight instruction to a commercial pilot samuel…Accident 20040421007069ACessna 182K · Durango, CO(-23) Aircraft encountered gust front which caused it to drift left from runway into soft dirt on the side of the runway. Nose gear sunk into soft dirt causing it to buckle and tear free from fire wall. Left wing was buckled slight from contacting ground. No…Incident 20040421006509IBeech V35B · Wetumpka, AL(-23) Lost control of airplane at touchdown due to gusty, 90 degree crosswind-porpoised on nose gear causing gear to break. Visual inspection of airplane concluded that there was no airframe damage, but noticeable damage to the nose gear strut and propeller.Incident 20040421005539IDhav DHC3 · Talkeetna, AK(-23) The pilot stated the aircraft departed Talkeetna state airport for the purpose of an office of aircraft services check ride. The aircraft landed at the kahiltna glacier and returned to Talkeetna. The pilot performed a normal wheel landing at Talkeetna.…Accident 20040420012859ABell 206L1 · Boonville, IN(-23) On April 20, 2004, at 2340 central daylight time, a Bell 206L-1, N137AE, operated by air evac lifeteam, collided with the terrain during a medivac flight. The patient was fatally injured. The pilot, paramedic, and nurse, on board were seriously injured.…Incident 20040420009309ICessna 401 · Dallas, TX(-23) The pilot requested a long landing on 13L at Dallas lovefield and the request was approved. N3217Q landed runway 13L and as the aircraft exited the runway to the left, the left main brake malfunctioned. The aircraft went into the grass at the end and to…Accident 20040420007729ACessna 177RG · Tampa, FL(-23) Pilot departed pompano beach airpark (pmp) pompano beach, FL at approximately 9:30 am enroute to Peter o'Knight airport (tpf) Tampa, FL. The pilot reported on tpf UNICOM that he was 6 miles out and was experiencing engine trouble and was requesting…Accident 20040420007399ACessna 208B · Kalaupapa, HI(-23) The flt. Departed ogg for hnl as tsunami 2005 at approx. 1511 HST (0111 UTC) with 4 pax. The pilot (single pilot operation) flew the a/c across the channel between maui and molokai at 2500 MSL. When he reached molokai the wx was good (VMC, vis >10…Accident 20040420005609APiper PA23250 · Fisher County, TX(-23) On April 20, 2004, at approximately 1835 central daylight time (CDT), N6257H, a Piper PA-23 twin engine airplane operated by a private individual, sustained substantial damage during an emergency landing in a field following an engine overspeed while in…Incident 20040419019819ICessna 441 · Latham, NY(-23) On April 19, 2004, at 1124 local time, a Cessna 441, N441S landed at albany international airport (alb) with the #2 engine shut down. Pilot performed precautionary shut down of #2 engine while at cruise altitude due to erratic torque indication. After…Accident 20040419018509AAviat A1A · Visalia, CA(-23) On 4/19/2004, at approximately 1800PDT, N40AW, piloted by [privacy data omitted] collided with N8321X on a parking ramp at Visalia Municipal Airport (vis). Both aircraft received substantial damage. There were no injuries. [privacy data omitted] States…Incident 20040419018109ICessna 182R · Garrison, ND(-23) Pilot attempted a landing at Garrison, ND airport and overshot the runway. Aircraft touched down approximately mid-field. The pilot initiated a go-around. This was the second go-around. The aircraft became airborne just before the (REIL) and contacted…Incident 20040419014869IEMB EMB145LR · Dayton, OH(-23) On 04/19/04 at approximately 1642Z jet link flight #bta 2005 declared an emergency for smoke in cockpit and engine vibration. They diverted to day and landed without incident. Maintenance reported a #1 engine had damage to the aft turbine blades and no…Accident 20040419011829ACessna U206A · Lake Havasu Cit, AZ(-23) The Cessna 206 registration number N4941F landed at lake Havasu airport (hii) lake Havasu, Arizona. The pilot stated it was a firm 3 point landing. The aircraft was taxied to the ramp area where the pilot inspected the aircraft for damage, pilot…Incident 20040419007559ICessna T210F · Corona, CA(-23) Pilot encountered a landing gear malfunction. Gear would not extend after several attempts to recycle. Pilot declared an emergency, landed on runway only to spin off on the dirt. Aircraft received only minor damage to the wing tip and elevator.…Accident 20040419007439ACirrus SR20 · Greenwood, SC(-23) On April 19, 2004, at 1400 eastern daylight time, a Cirrus SR-20, N8157J, departed from the Greenwood County Airport runway 27 and crashed into a wooded area 1,812 feet south southwest of the departure runway end. The aircraft was registered to attic…Incident 20040419007139IBeech C23 · La Verne, CA(-23) Mr. Yee, a student pilot, was on his first solo flight at Brackett (poc) airport. His instructor, [privacy data omitted] was supervising the flight from the ramp area. During Mr. Yee's third landing attempt, he began to porpoise, exited the runway…Accident 20040419006959APiper PA18150 · Berkley, MA(-23) N9862D had been utilized in a banner towing operation. The banner was dropped on runway 27 at Myricks Airport (1MI). The aircraft returned to land on 27 and crashed at 16:20 EST, 200 feet short of the runway end, 946 feet short of the displaced…Incident 20040419006219ICessna 150L · Fulton, MO(-23) The student pilot was doing solo takeoff and landing practice when he lost control of the airplane during a landing. On his fourth or fifth touch and go landing he lost directional control, went off the left side of the runway, collapsing the nose gear…Incident 20040419005569IAmrgen AA5A · Fullerton, CA(-23) On 4-19-04, pilot was on a straight in approach to runway 24 at Fullerton muni airport when he contacted an obstruction light with the left wing of the aircraft. The obstruction light was on top of a telephone pole in an adjacent rail yard at +22' AGL.…Incident 20040419005299IEMB EMB145LR · Pittsburgh, PA(-23) Chautauqua airlines flight 3057, an E145, declared a minimal fuel emergency at 1926E, and landed on runway 28R at 1940E, without incident. The inbound flight #3057 was given holding twice because president bush was preparing to depart pit but was…Accident 20040419005219ABbavia 7AC · Hayward, CA(-23) 04/19/2004: Pilot stated he was hit by a gust of crosswind after landing at the Hayward executive airport, after landing. Mr. Romanski stated he tried regaining control first and then left the landing, clipped a taxiway position sign and then the plane…Incident 20040418019739IPiper PA28RT201 · Parkersburg, WV(-23) Pilot failed to extend the landing gear while on approach to runway 21 at pkb and subsequently landed with the gear in the up and locked position. Submission of this report closes this incident. [privacy data omitted]Accident 20040418018219ABbavia 7GC · Wasilla, AK(-23) By definition the pilot a "student" is not competent see item 43.Accident 20040418017689APiper PA28161 · Holoaloa, HI(-23) Aircraft departed on a part 135 tour operation at 1620 from the Kona airport, Kona, HI with the pilot and 2 passengers. This was the first part 135 flight for the pilot after successfully completing a part 135 checkride on April 15, 2004. The aircraft…Accident 20040418016699AAmtr Glasairiii · Lakeland, FL(-23) Pilot elected to try to salvage an unsable approach and touched down with only the left main on the runway surface. The nose and right main were tracking in the grass/dirt off the right side of the pavement. The nose wheel struck a taxiway light and…Incident 20040418016309IDoug DC983 · Ft Lauderdale, FL(-23) [privacy data omitted] flight 814 in cruise @ flight level 310 approx 200 miles NE of kfll, crew heard loud bang accompanied by yaw. EGT and oil temp abnormally high. Qrh for "severe engine damage" carried out emergency procedure and secured engine.…