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 20040813016439IPiper PA34200T · Seattle, WA(-23) Director of maintenance alan nicol informed the Seattle FSDO that aircraft N81070 experienced a propeller strike on the right engine. There was damage on each of the three blades. Found acft parked on airport.Incident 20040812022199IPiper PA28RT201 · Rochester, NY(-23) On August 12, 2004, at 1626 EDT, a Piper 28RT-201, N2218Z, operated by Mr. Joseph hood, during cruise flight at 6000 feet, experienced an uncommanded landing gear deployment. The pilot declared an emergency and returned to the Rochester airport. After…Incident 20040812021679IBell 222U · Rialto, CA(-23) On August 12, 2004, at the Rialto airport, Rialto, California, a bht 222U, operated by lifenet sustained minor damage after the main rotor blades contacted the engine cowling. The mechanic reported that the aircraft had fluctuating #1 engine oil…Incident 20040812021329ICessna 402B · Portland, OR(-23) On descent from 14000, the pilot noticed a door light illumination. He checked the rear door which appeared normal and when he reached for the left crew door handle, the door opened fully and rested on the top of the fuselage. Further investigation by…Incident 20040812020499IDoug DC915F · Imperial, CA(-23) Tom loumamkin is the owner and operator of sky ways enterprise in kissimmee, fla. 34741. Mr. Loumamkin was also the PIC of N112PS. William serra was the first officer and the pilot flying when they landed at ipl airport on 8/12/04. Witnesses said his…Accident 20040812019339ACessna 172L · Webster, WI(-23) While enroute to duluth, MN airport from anoka, MN airport - the pilot twice reported 'severe vibration.' The aircraft impacted a hay field north of Webster, WI at approximately 35-55 degree angle at an estimated 195 knots. The pilot was fatally…Accident 20040812019319AMooney M20K · Marthas Vineyar, MA(-23) Untermeyer stated that he completed an IFR flight from kpne and was downwind on a visual approach for runway 24 at mvy. He reported that he was asked by the tower if he wanted to land runway 15 which he accepted, turned onto final, stabilized his…Accident 20040812019289ACessna 172M · Brownvillejunct, ME(-23) Aircraft departed pushaw lake, ME enroute to lobster lake, ME on 08/12/2004 at 0715 EDT. Weather reported at 0758 at millinockett, Maine (MST) 25 NM northeast of the accident site included an overcast ceiling at 700 feet above ground level (AGL).…Accident 20040812019199ACessna A185F · New Braunfels, TX(-23) On landing, the student encountered crosswinds. The aircraft skidded to the left side of the runway on the outbd. Side of the right tire before the right wing made contact with the runway. The aircraft went onto its nose when the right tire went into…Accident 20040812018429AAirtrc AT301 · Cambridge, KS(-23) A pilot operating his at 301 airtractor under part 137 on a private asphalt airstrip crashed off the end of the runway just after becoming airborne. The aircraft was carrying approximately 80 gallons of fuel and 260 gallons of chemical. The pilot did…Accident 20040812018419ACessna 172S · Miami, FL(-23) Mr. Vedros stated that on August 12, 2004 at approximately 1250 local time, him and his wife departed marathon, Florida airport, heading to Tamiami Airport, to secure the aircraft in Tamiami, due to the threat of incoming hurricane charley in the area.…Incident 20040812017509IPiper PA31310 · Mckinley Park, AK(-23) According to the company's chief pilot, the airman got crosswise with the aircraft checklist and forgot to put the landing gear down.Incident 20040812017499IAmtr Cozyiii · Bakersfield, CA(-23) Mr. Austin flew N399BR from L45 to kbfl under VFR. After takeoff from L45, he forgot to raise the nose gear. While preparing to land at kbfl, he manipulated the landing gear control thinking he was lowering the gear when he was actually retracting it.…Accident 20040811028169AMooney M20J · Huntington, IN(-23) Aircraft was practicing takeoffs and landings. Pilot lost control in a crosswind/wind shear. Aircraft crashed south of runway from approximately 50 feet altitude.Accident 20040811028079ACessna A188B · Mylo, ND(-23) The pilot of the single place aircraft began a descent over a barn, house and trees to apply chemical to a field of sunflowers. The field being approached was down an incline approximately 100 feet below the house and barn. As the pilot would have…Incident 20040811021249IGulstm 500B · Omaha, NE(-23) N127KH being operated by central air southwest inc., departed Omaha, NE., on a flight to Kansas city, MO. At approximately 500 feet of altitude the right engine shutdown and the pilot declared an emergency. The pilot returned to the airport and landed…Accident 20040811021019AScwzer G164B · Moville, IA(-23) The aircraft struck a tree while conducting aerial application, causing significant structural damage to the aircraft. Due to this structural damage the aircraft impacted the ground and a post crash fire consumed the center section of the aircraft,…Accident 20040811018899ABell 205A1 · Leavenworth, WA(-23) Aircraft was conducting external load operations, delivering pallets of equipment for forest service, under forest service contract. Witnesses reported that tail rotor struck tall snag as pilot was maneuvering to depart area with a light external load…Incident 20040811018529IBoeing 777236 · Houston, TX(-23) During the after take off climb, the flight crew noticed a vibration accompanied by an unusual whining sound that did not change in amplitude after the crew retarded power. The eicas displayed a level 5 vibration msge for the l engine, but no fire…Accident 20040810028059ACessna 310Q · Nappanee, IN(-23) Pilot stated he aborted takeoff at about 120MPH after pulling back on the yoke and the elevators would not respond.Incident 20040810026189IPac 750XL · Barrigada, Guam(-23) Preliminary investigation results: the inspection of the tandem parachute system was delayed until September 22, 2004, due to hurricane activity in Florida where the equipment was sent for the inspection. The initial inspection of the uninsured relative…Incident 20040810023669IPiper PA28161 · Riverside, CA(-23) During touch and go maneuvers at Riverside, CA municipal airport aircraft experienced an engine fire on the ground. Fire department responded and extinguished aircraft fire. Flight was terminated uneventfully.Accident 20040810019349ABlanca 1730 · Austin, TX(-23) Plane starved for fuel on ILS-17L approach to Austin bergstrom international and pilot attempted to recover by switching tanks, and then using fuel boost. Pilot was unable to fully recover in time and resulted in a forced landing at closed Austin's…Accident 20040810019249AMooney M20J · Durango, CO(-23) This is a preliminary report. All the facts are not known yet at this point in time. An amended report will be issued once all relevant facts are known. (-23 amendment) on August 10, 2004, at 16:05 MDT, Mooney M20J, N6212Q, piloted by david lee feller,…Incident 20040810019149ICessna 172L · Concrete, WA(-23) During cruise at an altitude of approximately 8000 feet, over the area of Concrete, WA, pilot experienced a rough running engine. The pilot attempted several ways of identifying the problem, but no change. Pilot decided to descend and land at Concrete…Incident 20040810019009IDhav DHC6300 · Grand Canyon, AZ(-23) While landing at gcn, the aircraft veered to the left and departed the runway. The aircraft then struck a runway edge light with the nose gear and a frangible taxiway sign with the right main landing gear. Witnesses who observed the aircraft on final,…Incident 20040810018029IPiper PA24250 · Puyallup, WA(-23) On August 10, 2004 at approximately 08:00, richard engstrom was piloting N5442P a Piper PA-24-250. He entered the traffic pattern for a landing at Thun field in Puyallup. After entering the pattern from the 45, he lowered the landing gear and the flaps.…Accident 20040810017879ACessna 152 · Abita Springs, LA(-23) Aircraft departed runway 36, night VFR just after heavy thunderstorms. Aircraft impacted trees at an approximate heading of 045 and 1888 feet from runway end. The aircraft then traveled through trees another 199 feet at a heading of 097 and impacted the…Accident 20040810017699APiper PA28181 · Scottsdale, AZ(-23) Student pilot was solo on his third landing as he flared to land the aircraft landed hard and bounced back into the air. Student pilot pushed forward on the control wheel, considered adding power; however aircraft nose was pointed at the ground. Student…Incident 20040809025559ITmpson Naviona · Greenwood, MS(-23) Night proficiency flight. 3 each night touch & go landings. On final, full stop landing, 6 or 7 deer crossed the active runway in front of the aircraft. Aircraft struck one of the deer with the left main landing gear. The gear broke off and the aircraft…Accident 20040809024779AUrocop EC130B4 · Denver, CO(-23) The aircraft was positioned on the ramp at the air methods maintenance facility. The aircraft was undergoing some avionics adjustments by two technicians, subsequent to an unsuccessful compass swing/test flight. A third maintenance person opened the…Incident 20040809022259ICessna 152 · Lakewood, NJ(-23) A student pilot, Mr. Louis w. illiano, was soloing a Cessna 152, N48231. On the second landing, the aircraft bounced and drifted to the right side of the runway. The aircraft then touched down off the runway and struck two (2) runway lights. The left…Incident 20040809019169ICessna T210L · Denver, CO(-23) While landing rw 11L, kbjc in VMC wx conditions, the aircraft touched down at approx. 3200' down the runway. The pilot lost control, veered left, crossed a non-paved area and the adjoining taxiway then came to rest on the paved ramp area. The aircraft…Accident 20040809018979ACessna 172P · Monarch, CO(-23) The aircraft crashed in mountainous terrain while attempting to cross the Continental divide at approximately 12,000 feet MSL in VFR conditions. Both pilots were qualified to be PIC but due to the post crash fire the pilot flying was unable to be…Accident 20040809018759AAmtr Wacoymf · Bar Harbor, ME(-23) Pilot reported that upon touchdown, a quartering gust of wind from the rear lifted the tail and flipped the aircraft over. Inspection of the aircraft revealed it was inverted on the left side of the runway facing 180 degrees from the initial landing…Incident 20040809017519IHughes 369E · Honolulu, HI(-23) On 08/09/04 aircraft N698DM made a precautionary landing at leeward community college, due to a tailrotor malfunction. There were two occupants during flight and no one was injured or aircraft was damaged.Incident 20040809016629IPiper PA46310P · Laconia, NH(-23) Per boston TRACON: "N9132V, pa 46 shortly after departing Laconia, n.h. pilot became incapacitated. Pilot's wife and daughter were passengers. Daughter contacted boston TRACON and advised of situation. With the help of the controller who was a pilot and…Accident 20040809016469AHughes 269C1 · Denton, TX(-23) Inspector worthy conducted the on-scene investigation and completed most of the required items. I was called on to interview the instructor who was the PIC of the aircraft, gene lacoste. I spoke with him the following day after examining the wreckage.…Incident 20040808034069IDiamon DA20C1 · Smyrna, TN(-23) Aircraft landed hard on nose wheel, nose wheel strut broke, allowing propeller to strike the runway.Accident 20040808027859AAmtr Freebird · Lexington, TN(-23) This inspector received notification of an aircraft accident at Franklin Wilkins Airport, Lexington, Tennessee, involving a non registered free bird ultra light on August 8, 2004, at 1017 central daylight time. The commercial pilot was fatally injured.…Incident 20040808025919IBoeing 717200 · Akron, OH(-23) Seat on aircraft was stained with blood from previous passenger. Flight attendants blocked seat. Passenger attempted to place luggage in blocked seat. When verbally and physically (hand on shoulder) directed away from biohazard area passenger hit flight…Accident 20040808024809AGlasfl H301LIBELLE · Yoder, KS(-23) During a local airplane tow glider flight, the pilot discovered that he was too FAR away from his intended point of landing because of the lack of sufficient thermal activity. The pilot picked a grass field but then discovered it was a plowed and disked…Incident 20040808023929ICessna 150F · Lockhart, TX(-23) After descending from 6500 ft to imitate cropduster and buzz some cattle, pilot attempted to add power and continue on his trip but the engine failed to produce power. Pilot landed aircraft on empty field causing minor damage to aircraft.Incident 20040808023899ICessna 414 · Roanoke, TX(-23) On August 8, 2004, at 1530 CDT, a Cessna 414, N8HM, registered to Mr. Dan l. boyd jr., 7730 fm 1830, argyle, Texas, upon landing slid off the left side of the runway following the failure of the right brake. The aircraft was on a personal flight under…Accident 20040808022909ACessna 172N · Wilkes Barre Sc, PA(-23) Student pilot on a cross country flight was making a landing at the Wilkes-Barre/Scranton international airport (avp) runway 4. Student pilot landed on the front nose wheel, breaking it off. The aircraft skidded off the runway. The aircraft sustained…Accident 20040808022619AAmtr MUSTANG2 · Rainelle, WV(-23) On August 08, 2004, at approximately 1345 EDT, an experimental amateur built mustang ii took off from rainele, WV (9W4) and reached altitude, when the aircraft experienced a loss of engine power, after the pilot reduced the engine throttle setting. The…Accident 20040808022339APiper PA32R301 · Pittstown, NJ(-23) Aircraft was on approach to runway 25 at N40, Sky Manor Airport and initiated a go-around. Aircraft failed to gain altitude and contacted the ground approximately 300 yards to the left of the runway in the front yard of a private home.Accident 20040808021049ACessna 305A · Frankfort, MI(-23) The pilot Mr. Eugene r. butler was piloting a Cessna-vansant aircraft, formerly a Cessna 305A (bird dog), while towing a schleicher, ASK13 glider, piloted by Mr. Richard l. ide. During the take off run there was a left crosswind. Before becoming…Incident 20040808020329ICessna 172L · Plymouth, MI(-23) The incident occurred on August 8, 2004 at Mettetal airport (1D2) Canton, Michigan, while practicing takeoffs and landings. The third and final approach was reported as above normal landing speed by the airport manager (Douglas r. kitze). All three…Accident 20040808019419ACessna 172S · Chandler, AZ(-23) During solo touch and go practice student lost directional control on takeoff roll. Student stated that after touching down approximately 1/3 down the runway he raised the flaps and increased the power for take off. Student stated that as he increased…