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 20040805017939ICessna 177RG · Missoula, MT(-23) Approximately 6 miles east of airport, pilot reported to mso tower that he was having trouble with nose gear. Nose gear would not extend. Pilot tried to cycle nose gear both manually and normally, both unsuccessful. Pilot declared emergency and landed…Accident 20040805016349APiper PA20 · Glendale, AZ(-23) Airman had just purchased this aircraft minutes before the accident. He holds a commercial pilot certificate however had not flown in the last 22 years other than his flight review and tail wheel endorsement for a total of 3.0 hours which took place…Accident 20040805016279ACessna 182F · Kustatan, AK(-23) Attempted landing on sandy strip. Aircraft flipped over upside down at end of strip. (-23 amendment) on August 5, 2004 at about 1245 Alaska daylight time, a Cessna 182-F airplane, N3481U, sustained substantial damage when it flipped upside down at the…Incident 20040804026009IPiper PA32R300 · Omaha, NE(-23) On August 4, 2004, at 10:41 central daylight time, the pilot of a Piper PA32R-300, N9134K, made an emergency landing at Eppley Airfield in Omaha, Nebraska, due to a failure of the aircraft electrical system. The aircraft landed without incident.…Accident 20040804023279ABell 47G5 · Palm Coast, FL(-23) At 1100 EST during aerial application the helicopter crashed into a marsh near the matansas waterway. The PIC sustained fatal injury and the helicopter was destroyed. NTSB and FAA investigation revealed the tail rotor gear box broke loose in flight from…Accident 20040804023219AMooney M20J · Olney, TX(-23) Attempted to land at ony. Overhead 360 type approach overshot final, over corrected, resulting in classic stall/spin killing all on board. Post crash fire destroyed aircraft.Accident 20040804019219AMooney M20R · Aspen, CO(-23) The flight was a sales demonstration from Texas to Aspen, CO, a route regularly flown by the pilot in command, allen anderson. During final approach to Aspen runway 15, the aircraft was high on the glide path with a 10 knot tailwind. Mr. Anderson said…Accident 20040804018689ACessna 208B · Big Rapids, MI(-23) 08/04/04: Aircraft departed grr and 3-4 minutes after leveling off at 7000', pilot reported getting cargo door warning light and then heard "thump", asked for vectors to nearest airport (rqb), landed without incident. Walkaround showed damage to left…Incident 20040804018619IUnivar 1083 · Chelan, WA(-23) Pilot was flying from everett, Washington to Montana when his vacuum pump failed. He landed at lake Chelan and taxied to Chelan airways to see if anyone was there. He circled around their dock area and when he didn't see anyone there, he turned around…Accident 20040804017829ACessna 172N · Cleveland, TX(-23) The pilot reported he had an overwhelming feeling of being lost while enroute to lufkin, TX. He became sick and determined he could not continueto fly. He elected to put the aircraft down in a field near Cleveland, TX. Mr. Box landed in a southeastern…Accident 20040804017339ACessna 402C · Huslia, AK(-23) PIC stated that he was preparing to land runway 3. While completing the prelanding checks he decided that runway conditions were in favor of switching to runway 21. During the change in pattern entry to runway 21 the PIC inadvertently omitted the…Accident 20040804015969APiper PA32260 · Mineral Wells, TX(-23) On August 4, 2004, at approximately 1135 local time, Piper PA-32-260, N3352W was operated by Mr. Donald duffy brooks when executing a go-around over runway 31 at Mineral Wells Airport, Texas. Eyewitnesses observed the airplane at approximately 200 feet…Incident 20040804015759ICessna 150M · Auburn-Lewiston, ME(-23) The student pilot stated that she was practicing solo short field take-offs and landings. The approach looked good but upon landing, the nose wheel hit first which launched the aircraft into the air and back down 3 times, each oscillation getting bigger…Incident 20040804015749ICessna 414A · Hyannis, MA(-23) N37150 taxiing from his hangar in hya struck an orange marker cone and an aluminum cargo loader causing damage to right engine propeller hub and two propeller blades.Incident 20040804015739ICessna 150L · Auburn-Lewiston, ME(-23) The CFI witness stated that the aircraft hit the runway nose first and oscillated up in the air 3 times. The aircraft was then taxied in, the pilot stated that the tail hit on the runway and bent over the tiedown hook. Upon examination of the aircraft,…Incident 20040804015429ICessna 402C · Key West, FL(-23) On August 04, 2004, at 2126 hours. A Cessna CE-402-C operated by cape air (hyia), flight number 9398 departed fort myers, Florida (rsw) for Key West, Florida (eyw) when the nose wheel collapsed upon landing at eyw. According to pilot eric w. sampson,…Accident 20040803035649ACessna 172F · Cooperstown, NY(-23) Pilot did not adequately correct for left turning tendencies encountered during take off. Airplane veered off left side of runway. Pilot did not abort take off early enough to prevent damage to airplane & injury to herself.Accident 20040803026919APiper PA24 · Philipsburg, PA(-23) N6311P departed runway 35 at phillipsburg mid-State airport at approximately 2145Z. After the aircraft became airborne off of runway 34 the aircraft began to descend and landed with the gear extended approximately 1/4 mile off the departure end of the…Incident 20040803025569ICessna 172RG · St Petersburg-C, FL(-23) On August 3, 2004, at approximately 11:00 hours, N5276U, a Cessna 172RG, serial number 172RG0319, registered to 5276U enterprises LLC, landed with the landing gear retracted while on a training flight. Visual meteorological conditions prevailed at the…Incident 20040803025489IPiper PA28161 · Knoxville, TN(-23) During an instructional flight conducting stop and go landings the aircraft engine stopped. The student and the flight instructor tried to start the engine for approximately five minutes. While they were trying to start the engine a fire erupted from…Accident 20040803023259ACessna 152 · Sarasota-Braden, FL(-23) On August 3, 2004, at 10:58 local time, a Cessna 152 N218JA, registered to jones flying service, inc. collided with the ground while landing at Sarasota (srq) airport, Sarasota, Florida while on the pilots first solo. Visual meteorological conditions…Incident 20040803021279IBoeing 73783N · Chicago, IL(-23) An American trans air Boeing 737-800 was parked on terminal gate # A-16 at Chicago's Midway airport on the night of August 3, 2004 when the aircraft was struck by a run-away refueling stand. The aircraft suffered two damaged flap fairings on the left…Accident 20040803021089AN601BV · Austin, TX(-23) N601BV an Aerostar 601P with richard allen fisher pilot certificate no. 44780566 departed the Lakeway airport Texas (3R9) at approximately 12:05 on August 03, 2004. The aircraft had the pilot and 5 passengers on board. The takeoff was initiated on…Incident 20040803020299IPiper J3C65 · Alpena, MI(-23) Aircraft developed engine problems and made an emergency landing on beach. No property or personal damage.Accident 20040803018799ACessna 182P · Port Angeles, WA(-23) On August 3, 2004, N79404 on a part 91 personal flight, a pilot and two passengers took off from the Port Angeles, Washington Fairchild international airport (clm) at about 2153 PDT. The aircraft shortly after take off at about 1100 feet turned right…Accident 20040803016869AAmtr RAF2000 · Beverly, MA(-23) After landing a gust of wind from the side caused the gyroplane to flip over.Incident 20040803015439IPiper PA18150 · Fairbanks, AK(-23) [privacy data omitted] this was a ground loop incident that occurred during a tail wheel check out utilizing an aircraft with oversized tires on pavement.Accident 20040802028849AAmtr KITFOXSERIE5 · Westfield, IN(-23) Pleasure flight was being conducted into the Westfield Indiana airport (I72) with the pilot practicing short-field pilot techniques. He stated that he allowed the airspeed to decay causing a high "sink rate." Power was added approximately the same time…Incident 20040802026609ICessna 310N · Corona, CA(-23) The pilot in command initiated a normal approach to the Corona airport. During the final approach phase the PIC encountered gusty wind conditions and misjudged his altitude on final and made a decision to go around. During the second approach the PIC…Accident 20040802023289ARobsin R22BETA · Everglades, FL(-23) Student Mr. Yonatan yoherbert martinez stated, that approximately 0930 local time, on August 2, 2004, him and the CFI pilot Mr. Chikao takayanagi, departed from tamiami airport heading west, for a 30 minute flight. This flight was his first flight ever…Accident 20040802020989APiper PA32300 · Point Lookout, MO(-23) The 3700 foot long runway was level, dry, and paved. The density altitude was about 3200 feet. The airplane was loaded within 100 pounds of maximum takeoff weight. The takeoff run was started at the approach end of the runway. Skid marks indicated the…Incident 20040802020629ICessna 172RG · Pontiac, MI(-23) Landed with gear up.Accident 20040802018849AMooney M20F · Brewton, AL(-23) Pilot reported that after leaving destin airport climbed to 4,500 feet (his cruising altitude) he trimmed the aircraft, closed the cowl flaps, reduced manifold pressure to 24 inches and the RPM to 2,400, at that point the engine quit. He called…Incident 20040802018539IReliantsx · Glenwood, AR(-23) Around 1820 EST on August 2, 2004, an ultralight, was operating around Glenwood, Arkansas, when the operator Mr. Lawrence sykes experienced engine failure, the vehicle impacted the ground causing minor damage and no injuries to the operator. Arkansas…Incident 20040802017959IBeech 400BEECH · Duncan, OK(-23) Crew reported an electrical problem with fumes on the flight deck. Crew reported completing check list items, went to emergency power. Smell went away. Then it seemed to come back. Crew turned the electrical off. Declared an emergency and made a high…Incident 20040802016489ICessna 180 · Lakeport, CA(-23) Pilot stated that he was out practicing for his biannual flight review. He had made a number of landings and this landing he hit the brakes a little too hard. The nose went down and the propeller struck the runway.Incident 20040801030949ICndair CL6001A11 · Teterboro, NJ(-23) Recieved NY TRACON incident report ^pri^ concerning a challenger 600, N515BP overflying the NY area. A/c declared an emergency @ 17,000' with an APU fire indication and an auto shutdown. They requested immediate descent to kteb. In the VFR descent,…Accident 20040801028269AConaer LA4200 · Oshkosh, WI(-23) Aircraft hit large wave on takeoff run. Became airborne, landed hard. Prop strike to fuselage, internal damage to structure.Accident 20040801026859AAmtr Lancairlegay · Madison, WI(-23) I was contacted by roc at approximately 1850 that a small aircraft, a Lancair legacy 2000, N98SN had crashed short of the Madison Wisconsin airport (kmsn) while in route from the oshkosh airport (osh) attempting an emergency landing. It was unknown at…Accident 20040801023499ACessna 172S · Waterloo, AL(-23) The accident aircraft was flying near Waterloo, Alabama just above the Tennessee river at approximately 1600 hours on August 01, 2004. Several witnesses stated they observed the aircraft flying parallel to the shore line as if it were looking for…Incident 20040801022809IPiper PA31310 · Manville, NJ(-23) After landing on runway 25, the right main landing gear collapsed. The right wing and the right landing gear door received minor damage. Appears that dirt and rust had accumulated on the downlock, as the aircraft had been out of service for five weeks.…Accident 20040801021449AAmtr RV4 · Collinsville, TX(-23) On August 1, 2004, N7XD, a drzymala peter s, model RV-4, serial number 2026PD, owned and operated by william e. noel, sustained substantial damage after collision with the ground. The pilot and passenger both received fatal injuries. There was no fire.…Incident 20040801019049IBeech 200BEECH · Van Nuys, CA(-23) On August 1, 2004 Beech king air N280TT experienced a right engine failure in level flight while it was being operated for hire by sun quest executive air charter, (eiea). Investigation revealed that the failure was a result of fuel exhaustion. After a…Accident 20040801018789ACessna 150C · Mazama, WA(-23) Aircraft departed lost river airport, a gravel-strip at 2415 feet elevation, and length of 3150 feet. Temperature was reported to be 92 degrees, with 23% humidity and wind at about 6 knots. Aircraft was unable to climb enough to safely clear terrain,…Accident 20040801017782AAmtr Parakeet · Kingston, OK(-23) Mr. Pellegreno landed N14843, at 0830 hours, at Kingston, OK, F31 and was moving the aircraft under its' own power to the aircraft parking area. The aircraft was about 500' from the end of 36. At this time N2632N collided with N14843, while attempting…Accident 20040801017781ACessna 140 · Kingston, OK(-23) N2632N was reported to be the last aircraft to land at Kingston airport, F31 at 0830 hours for a flyin breakfast. He was landing on 18, the winds were calm at the time. During the touch down phase of this flight, N2632N collided with another aircraft,…Accident 20040801017399APiper PA22150 · White Sulfur Sp, MT(-23) On Sunday August 1, 2004, while receiving instruction towards his taildragger endorsement in N3838P, PA-22-150, private pilot jeremy maus landed at White sulphur Springs, MT (7S6). During rollout the tail wagged back and forth and jeremy overreacted and…Incident 20040801017139ILBL LBL105A · Littleton, CO(-23) During the approach to an alternate landing site, the balloon encountered a wind increase, down drafts and turbulence. The basket struck the roof of a house and settled down in the adjacent open area. Minor damage to the house, basket and envelope.Accident 20040801016099APiper PA24260 · Redmond, OR(-23) The PIC stated he and his front seat passenger, also a rated private pilot with complex experience, confirmed the gear handle was down with a "green" light illuminated indication. ATC cleared N9394P for landing on rwy 28. The PIC used flaps 15 for the…Accident 20040801016049AAmtr WITTAILW10 · Langley, WA(-23) I was notified by roc about 1330 PDT 8-1-04. I proceeded to Whidbey island and met the sheriff near Langley. I surveyed the damage that was complete due to fire and impact damage. The body of Mr. Hagler was removed by the time I arrived. There was no…