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 20040224001859IPilats PC12 · Dallas, TX(-23) The aircraft was struck by lightning during landing approach at dal. The PIC noted the strike cracked the aircraft windshield. The PIC informed the dal ATC tower and declared an emergency landing. Runway 31R was cleared of all traffic and the PIC landed…Incident 20040223014929IBoeing 757223 · Wichita, KS(-23) Flight attendants notified the flight crew of electrical smell in the forward cabin, which became apparent in the cockpit along with a "standby inverter" advisory. Qrh procedures were accomplished and an emergency diversion to ict (nearest suitable) was…Incident 20040223012989ICessna 177RG · Orlando, FL(-23) On downwind and opposite the numbers the tower asked if a short approach could be made. The answer was affirmative and resulting in a slightly hurried up approach. The pilot stated that he failed to put the gear down and because part of the flight was…Accident 20040223011849AScwzer G164C · Hazen, AR(-23) On February 23, 2004 at 1416 central standard time a Grumman G-162C single engine agricultural biplane N6721K, was registered to and operated by skarda flying service inc., of Hazen Arkansas, was destroyed when it impacted terrain while maneuvering…Accident 20040223003569ACessna 172N · Youngstown, OH(-23) Pilot statement attached. We inspected aircraft at Elser airport and found the following: 1) right flap bent - probable initial impact with deer. 2) right horizontal stabilizer outer 1/3 substantially damaged from impact with deer with continuing damage…Accident 20040223002899APiper PA46310P · Arlington, AL(-23) On Monday, February 23, 2004 at 8:49 CST N9103Z, a Piper PA-46-310P on an IFR flight plan from panama city, FL (pfn) to tulsa, ok (rvs), broke up in-flight near Arlington, Alabama. Review of the radar data revealed the airplane was at 24,000 feet,…Incident 20040223002379IPiper PA32260 · Dwight, IL(-23) N3307W was enroute from the crystal Minnesota airport (mic) to the purdue univ airport (laf) at 7000 feet when PIC Garrett raddohl experienced a catastrophic engine failure. Subsequent investigation revealed a number one connecting rod failure. Aircraft…Accident 20040223001789AGarlik UH1H · Ellensburg, WA(-23) On February 23, 2004 N6257P, a military surplus 1963 garlick UH1-H helicopter crashed at a logging site located 16 miles north of Ellensburg, Washington on us forest service property. The aircraft sustained substantial damage or maybe determined to be…Incident 20040223001389IBeech C90 · Gilbertsville, KY(-23) During taxi back to the parking spot the pilot felt as if he ran over a speed bump and then thought he heard a difference in the sound of the props. After parking the aircraft the pilot performed a walk around and discovered two bent blades on the left…Accident 20040222031169AHiller UH12B · Bradenton, FL(-23) On February 22, 2004, at 1140 EDT, a Hiller UH-12B, registered to danny bals, engine quit due to fuel depletion and auto rotated into panther park, Bradenton, Florida. On landing the pilot lost control and the helicopter flipped on its side. The pilot…Accident 20040222022439ACessna 182P · Titusville, PA(-23) Mr. Nasralla stated that he obtained a computer weather briefing at approximately 1000 on 2/22/04, and departed 6G1 in N7388N at approximately 1500 for a local flight. Returning to 6G1 he made a normal approach to runway 36. Wind was approximately 310…Accident 20040222005669ACessna 182A · Claremore, OK(-23) Pilot and passengers stated the aircraft take off was normal, however, during climb out the aircraft had a loss of engine power at approximately 500-600 feet. Pilot turned aircraft to land on a grass strip, picked up a 10-15 mph tail wind, increasing…Accident 20040222004649ACessna 210N · Valley Spring, TX(-23) The aircraft crashed 4.5 miles north of the llano VOR. The sole occupant of the aircraft died in the crash. The aircraft came apart in flight. Debris from the crash was from southeast to northwest on an approximate heading of 320 degrees. The scatter…Incident 20040222004629IPiper PA34200 · Fort Worth, TX(-23) On February 22, 2004, at 1930 CDT, a Piper seneca PA-34-200, N4567T, owned by eagle eye aviation, inc. of venus, TX., had an incident upon landing at Fort Worth Spinks Airport. Mr. Joe d'silva had landed the aircraft safely on the runway and after…Incident 20040222003969IPiper PA28RT201T · Minden, LA(-23) Pilot reported a decrease in power even after switching to his electric fuel pump. Pilot requested a vector to Minden airport, but could not hold altitude. Pilot elected to land westbound on interstate 20 (I-20 at exit 38) and departed to the shoulder…Incident 20040222002509IStnson 10STNSON · Hulett, WY(-23) Pilot lost directional control of the aircraft upon landing.Incident 20040222002489ICessna 340A · Casper, WY(-23) During climb out, the pilot noticed the right engine oil pressure gage indicating a significant increase in pressure. When the right engine started to run rough the engine was secured and the propeller was feathered as a precaution. The aircraft…Accident 20040221030369ABell 206BELL · Locust Grove, GA(-23) Examination of the crash site was conducted on February 22, 2004. The pilot stated he was attempting to reposition the helicopter on a dolly in order to move it into his hangar. He had just returned from a VFR flight from andrews north carolina. The…Accident 20040221013709ACessna 172P · Tampa, FL(-23) On February 21, 2004, at 1330 EST, a Cessna 172, N612CB, registered to helicopter structure and maintenance, collided with the ground at Tampa north aero park, lutz, Florida, while on a training flight. Visual meteorological conditions prevailed and no…Incident 20040221010599IBeech N35 · Chickasha, OK(-23) Preflighted aircraft. A/c had not flown in over a month and required a jumpstart. Door popped open on first takeoff and required landing to close door. On second takeoff, climbed to 2000 feet and experienced a complete electrical failure. Continued…Incident 20040221004639IPiper PA28R200 · Grandbury, TX(-23) On February 21, 2004 at 1705 CDT, a Piper, PA-28R-200, N9342N, owned by ruth coles fletcher, [privacy data omitted] had an incident upon landing at the granbury airport. Mrs. Ruth coles fletcher had landed the aircraft safely upon the runway and while…Accident 20040221003749ACessna 120 · Merrill, WI(-23) On Saturday, February 21, 2004, at 1655 EST a Cessna CE-120, N73034, struck a rut in the snow with the right ski causing the aircraft to flip over while landing on the Wisconsin river approximately 5.75 miles northwest of Merrill, WI. The private pilot…Accident 20040221001679AAmtr Sportcopter · Marysville, CA(-23) Gyro copter N96XV was flying downwind, 1 mile south of myv, about 50 feet above AGL heading north. A witness heard the engine sputtering and saw the aircraft descend at a 45 degree angle and impacted the feather river bed. The pilot was fatally injured.…Incident 20040220014179IBeech V35A · Clearwater, FL(-23) On February 20, 2004 at 1340 EDT, a Beech V35A, N2452A, registered to four fox air inc. landed with the gear-up at Clearwater air park, Florida while on a pleasure flight. Visual meteorological conditions prevailed at the time and an IFR flight plan was…Incident 20040220013059ICessna T210F · Sarasota-Braden, FL(-23) On February 20, 2004, at 1538 EDT, a Cessna 210-T210F, N6112R, registered to richard strub, landed with gear up at Sarasota international airport, Sarasota, Florida. Visual meteorological conditions prevailed at the time. The aircraft sustained minor…Incident 20040220013029IPiper PA28180 · Maxton, NC(-23) Pilot was on a VFR flight at approx. 6500 feet near kmeb when his engine quit. Mr. Williams was in contact with fay ATC and informed them of the situation. He was informed of the closest airport but due to a strong headwind was forced to execute an off…Incident 20040220007929IGulstm 690B · Syracuse, NY(-23) On February 20, 2004, at 1951 EST, a rockwell international GA-690-B, s/n 11536, N260WE, operated by EMS air service of NY inc., experienced a control problem on climb out from the Syracuse international airport (ksyr). The aircraft returned and landed…Incident 20040220003589ICessna 182M · Palo Alto, CA(-23) The pilot was high and fast on approach and failed to stop the aircraft before it departed the end of the runway.Accident 20040220001779ACessna 150J · Longview, WA(-23) The individual was conducting a pleasure flight in vicinity of Longview, WA. After 1+ hours of flight, cruising at approximately 1000 feet, the engine quit. The pilot attempted to re-start one time but failed. The pilot then lined up on a vacant pasture…Accident 20040220001759ALear 25B · Ft Lauderdale, FL(-23) Aircraft departed luis munoz marin int'l airport in san juan, puerto rico to ft. Lauderdale executive airport (fxe). Pilot contacted fxe tower and stated minimum fuel. Upon landing complete hydraulic failure (zero flaps) on touch down. Engines shut down…Accident 20040219018459AScwzer 269D · San Antonio, TX(-23) While in cruise flight, the helicopter lost power. Pilot maneuvered helicopter over some power lines which depleted his air speed. Helicopter crashed-landed in a grocery store parking lot. No injuries to flight crew, no fire and no NMAC. The helicopter…Accident 20040219013669ACessna 172P · Clewiston, FL(-23) Investigation reveals that the solo student pilot lost control over the aircraft during landing. The accident took place at Airglades hendry county airport (2IS). On runway 13, the aircraft porpoised thus causing the nose gear to collapse. The propeller…Incident 20040219012999IPiper PA34200 · Palatka, FL(-23) On touchdown the right main landing gear collapsed. An FAA inspection of the aircraft revealed that the right main landing gear trunnion front and rear fitting assemblies were broken in the center causing the gear to fold rearward on touchdown.Accident 20040219008799ACessna 177RG · Manitowoc, WI(-23) N7751V, a CE-177-RG was completing it's runup prior to a CFI flight test when it was struck by N4351V, a CE-195, which was taxiing to parking after landing. The NTSB assigned an id number only to N4351V. They decided not to issue any number to N7751V.Accident 20040219008789ACessna 195 · Manitowoc, WI(-23) N4351V, a CE-195 was taxiing back to parking after landing when it struck N7751V, a CE-177-RG, which was completing it's runup prior to departing on a CFI flight test. The NTSB assigned an id number only to 4351V. They decided not to issue any number to…Accident 20040219004389AAyres S2RT34NORMAL · Mamou, LA(-23) Just after take off, @ 300 ft. altitude the aircraft engine began to surge. After the second surge the engine spooled down completely which resulted in the aircraft descending rapidly, impacting the ground and sliding approximately one hundred and…Incident 20040219004249IAmtr MJ90 · Marana, AZ(-23) After a normal landing (touchdown) and rolling out the landing gear suddenly collapsed causing minor damage to the "belly" center section. No poilot injuries or post event fire.Incident 20040219001899IAmtr LANCAIR235 · Aurora, OR(-23) The pilot entered the traffic pattern at the airport and was conducting pre-landing checks when he was distracted by a radio call of another aircraft in the pattern. After locating the other aircraft the pilot was in a position to turn base and forgot…Incident 20040219001699ISnias AS350BA · Las Vegas, NV(-23) Pilot reported control problems to las ATC at approx 0125 UTC. Pilot continued flight to airport where emergency services were available and made 8 attempts to land, landed safely on runway (1L) on last attempt skidding approximately 1000 yards and…Incident 20040219001609IBell 407 · Madera, CA(-23) While attempting an approach maneuver into the Madera airport and conducting initial (new hire) flight training, the crew felt the rotorcraft initially experience a momentary heavy shudder through the airframe. This immediately was followed by a load…Accident 20040218015129ABell 206B · Decatur, TX(-23) Aircraft was operating in a large field doing fire bucket operation/training with a U.S. Forest service crew. Pilot was attempting to pick up the canvas water bucket in the unimproved field. It appears that the rear portion of the right skid dug into…Accident 20040218013699ARobsin R44RAVENII · Daytona Beach, FL(-23) During initial lift-off at approx 5' off the ground the pilot stated that gusty winds caused the aircraft to slide left 5-6 feet. The helicopter descended and the left skid impacted the ground. The pilot was unable to correct the rollover movement and…Incident 20040218013009ISocata TB20TRINIDAD · Tallahassee, FL(-23) On February 18, 2004, at 14:07 local time, a Socata TB-20, registered to trb aircraft, inc., after landing on runway 9 with a crosswind had the right wing contact the ground while on a pleasure flight at Tallahassee regional airport (tlh). Visual…Accident 20040218007669APiper PA22135 · Memphis, MO(-23) Aircraft departed burlington, IA. Enroute to Memphis, MO. At 1441Z landed at Memphis on runway 12, winds reported at kirksville MO. (12 NM sw of Memphis) 21018G27. The landing was normal just to the right of centerline, the aircraft was on rollout then…Incident 20040218005329ICessna 150J · Aliceville, AL(-23) Student pilot had just completed a 2 hour dual training flight with his instructor in preparation for his private pilot practical test. After refueling he decided to practice some solo closed traffic. On climb out after his third take off, at…Incident 20040218002369IPiper PA28R201 · Grand Forks, ND(-23) On 02-18-2004 at 0931 CST, a PA-28R-201, N283ND, owned by the university of north dakota and flown by erin e. olson lost directional control upon landing at Grand Forks international airport (kgfk), ND. The private pilot and sole occupant had returned…Accident 20040218001489APiper PA31325 · Kahului, HI(-23) [privacy data omitted] the aircraft is canadian registered and was being flown by a canadian registered professional ferry pilot. Approximately 4 hours out of phnl en route to koak the pilot reported to ATC that he was unable to keep the right engine…Incident 20040218001469ICessna 210A · Winnsboro, SC(-23) Pilot admitted up front that he forgot to lower gear when landing his CE-210, reg. #N9424X at Winnsboro, CO. Airport at 1730HRS on the 02/18/04. One pax on board, no injuries and minor damage to aircraft.Incident 20040217010589IBoeing 737824 · Lake Charles, LA(-23) Aircraft encountered mod/severe turbulence while descending from FL350 into houston (iah). Aircraft dispatch release included the remark "planned low across gulf for possible severe turb at FL280 to FL360". Paramedics met the aircraft at the gate after…Incident 20040217008249IBoeing 717200 · Buffalo, NY(-23) On February 17, 2004, at 1134 am EDT, a Boeing 717, N956AT, flight 558, operated by air tran airlines landed on runway 23 at Buffalo international airport after reporting a cracked windshield. Fire and rescue responded. The aircraft taxied to the gate…