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 20040229006089IGulstm 680F · San Diego, CA(-23) Pilot was concluding an IFR flight from hhr (hawthorne) to myf (Montgomery field). Following ILS approach to runway 28R, pilot touched down and employed his usual procedure of holding the nose wheel off the ground as long as possible, to facilitate…Accident 20040229005559APiper PA15 · Skwentna, AK(-23) According to the pilot, while in cruise flight the aircraft suddenly went into a left bank and nose down attitude. When the pilot reduced power the bank and nose down angles increased. The pilot was able to reduce the left bank and nose down attitude…Incident 20040229004569IBeech A36 · Sunderland, VT(-23) Dr. Jeffrey epstein, PIC Beech bonanza N916EB, experienced engine failure 12 miles north of bennington, VT. While cruising at 7,500'. The aircraft landed on route 7 in Sunderland, VT.Accident 20040229003199ACessna 170 · Herron, WA(-23) Pilot departed diamond point airstrip (2WA1) sequim, WA. Enroute to auburn municipal airport (S50) auburn, WA. Radar contact had the aircraft at an altitude of 500 feet over case inlet when the aircraft began a descent at a rate of 1000 feet per minute.…Accident 20040229003189AAmtr Airbike · Elko, NV(-23) On 02/29/04, 0920 PST, this experimental home-built wilson alan tandum air bike, N240JC, experienced a total loss of engine power while cruising about twelve miles south of Elko, Nevada. The owner/builder and his wife were aboard and he made a forced…Accident 20040229002959ACessna 172K · Angleton, TX(-23) Non-pilot took off in stolen aircraft. Struck high tension power lines and crashed. Operator walked away undetected and apparently uninjured.Accident 20040229002849APiper PA28180 · Mariposa, CA(-23) [privacy data omitted] was acting as pilot in command of aircraft N5205L, which he owned, on a cross country flight from fullerton (ful) to Mariposa (O68), CA. He descended from 10,000 feet MSL in preparation for approach into Mariposa, CA. At 4,500…Accident 20040229002829ACessna A185F · Tucson, AZ(-23) Pilot stated that upon arrival at Tucson intl. Airport, he was instructed to land on runway 11R. He further stated that he used poor discretion in accepting the runway because it had a 10KT. Tailwind. He added that when he landed he lost control due to…Accident 20040229001729AAmtr Q2 · Portland, OR(-23) Pilot encountered heavy rain vw engine became rough advised tower and began left down wind for runway 20 hio. Landed long and hard, lower spar failed causing loss of directional control. Airplane stopped at end of runway. Heavy damage to spar, cabin and…Accident 20040228021119AHughes 269C · Media, PA(-23) Student pilot flying solo experienced tail rotor failure. While attempting an emergency landing in an open field the student demolished the aircraft as a result of the main rotor making ground contact.Accident 20040228013719ASwrngn SA226T · Collegedale, TN(-23) On February 28, 2004 at 15:40 eastern standard time, a swearingen, SA-226T, N70FC registered to william d. fisher enterprises LLC., operating as a 14 CFR part 91 personal flight, veered off the side of the runway during landing rollout at Collegedale,…Accident 20040228011559ARobsin R44 · Burlington, WI(-23) On February 28, 2004, at 1145 CST a Robinson, R-44 rotorcraft, N7184G, struck and severed an electrical power wire adjacent to a refueling tank, during takeoff in Burlington, WI. The private pilot, rotorcraft rated pilot was not injured and one…Incident 20040228010699ISwftms GC1B · El Dorado, AR(-23) On February 28, 2004, at approximately 1145 CST, temco swift, N3817K, experienced a 'nose over' during landing rollout at eldorado, Arkansas. The commercial pilot stated that, after landing, he experienced an uncontrolled turn due to wind gust. In an…Incident 20040228006599ICessna 210G · Rockford, IL(-23) Pilot was on a return trip to his base of operations, Rockford airport, Illinois, when he noticed that the landing gears would not extend fully for his intended landing. Nose gear was down and locked, but the main landing gear would not lock down. The…Accident 20040228006169APiper PA28236 · Bourbon, IN(-23) Accident investigation revealed excessive brake wear. About 20% brake surface being utilized on both brake discs combined. Last annual inspection did nothing to address this problem and corrective maintenance was not initiated or entered into aircraft…Incident 20040228004539IPiper J3C65 · Millinocket, ME(-23) Mr. [privacy data omitted], PIC of Piper cup N1401V, noted the surface of the ice was rough during takeoff from lake chesuncook. After takeoff pilot felt something wasn't right and noted the right ski was dangling from the strut by the bungee cords.…Accident 20040228004349AConaer LA4250 · Lake Arthur, LA(-23) Pilot made approach to land on grand lake and lowered the landing gear instead of flaps. Aircraft flipped over upon contact with water.Incident 20040228004259ICessna 172M · Mesa, AZ(-23) While practicing touch & goes on RY-22 @ ffz, the pilot touched the runway on his third t&g. than as he powered "up" he found that the a/c had drifted to the left. The pilot elected to land quickly, placing the l/h main wheel in the dirt to the left and…Accident 20040228004039ACessna 120 · Red Bluff, CA(-23) Cessna 120, N3029N, came to rest inverted after a loss of directional control on landing at a Private strip near Red Bluff, California. The airplane was registered to a Private individual and operated by the pilot under the provisions of 14 CFR part 91.…Accident 20040228003579AUnivar A2ALON · Hawley, MN(-23) Five miles northwest of Hawley, Minnesota (K04Y) engine started to run rough. Pilot did not feel he could make it to Hawley (K04Y) and landed on gravel road. Plane slid into ditch while pilot tried to avoid a mailbox and slid down into the ditch…Incident 20040228003439INancng CJ6A · Torrance, CA(-23) After departure from toa pilot, craig t. eckberg, experienced a loss of engine power. Pilot elected to return to airport and initiate a gear up landing. Aircraft incurred minor damage. (Other) engine and propeller have been replaced.Accident 20040228002909ACessna T210M · Grape Creek, TX(-23) On February 28, 2004, at approximately 20:46 UTC, a Cessna T210M, N50MC, owned by buetler brothers and cervi rodeo company and operated by [privacy data omitted], crashed approximately 12 miles northwest of san angelo, Texas. VFR flight conditions…Accident 20040228002859ARaven RX7 · Lexington, KY(-23) On February 28, 2004, at about 1630 EST (2130Z), an Aerostar Raven RX-7 rally, N4110M, contacted power lines during takeoff, resulting in fatal injuries to the pilot, who was the lone occupant of the aircraft. The balloon was placed on the ground on a…Incident 20040228001979IMooney M20C · Atlanta, GA(-23) Pilot experienced smoke in the cockpit on climbout. Pilot declared emergency and returned to land at pdk airport. Landing accomplished with no injury to persons or damage to aircraft or equipment. Postflight inspection revealed that a section of the…Accident 20040227011179APiper PA28R180 · Pinemontainclub, CA(-23) The aircraft crashed into a mountain north of pine mountain club, CA at 6683 feet elevation. The audio tapes indicate that the pilot was trying to stay VFR enroute to sacramento. The pilot was advised by bakersfield approach that he was below the mva…Incident 20040227008209IDoug DC982 · Ontario, CA(-23) On aala flight #451, from dfw to ont, passenger [privacy data omitted] struck flight attendant (fa) [privacy data omitted] during the flight, she became obnoxious, and verbally rude to the cabin crew and passengers. She was drinking wine prior to the…Accident 20040227008099AGulstm 112 · Jackson, MI(-23) Left main tire blew out on landing, aircraft veered to the left, the flight instructor took over and tried to correct. The aircraft slid forward into a snowbank at which time the nose gear collapsed.Incident 20040227006249IBeech 36BEECH · Hays, KS(-23) Pilot reported aircraft departed brighton co (CO12) to quinter KS (6KS1). He had no problems with the aircraft. They departed quinter KS (6KS1) 10 minutes after climbing to an altitude of 7,500 feet the aircraft engine quit abruptly. He made one attempt…Incident 20040227006229IBeech 76 · St Charles, MO(-23) The pilot was practicing takeoff and landings to include simulated engine landings at st. Charles county airport (kset) utilizing runway 18. The pilot encountered numerous distractions during the incident traffic pattern. A single engine aircraft…Accident 20040226022329APiper PA28181 · Corry, PA(-23) 2/27/2004: Eastern region operation report for 2/26/2004 stated that at 2018E, N4166P, a pa 28, reported a rough running engine 22 miles east of the facility and shortly after lost radar and radio contact. After eyewitness accounts reported observing an…Incident 20040226016609ICessna 180K · Clarksburg, CA(-23) Pilot radioed in with loss of power and performed an uneventful landing in crosswinds using a service road along an abandoned railroad track. At the final moments of the rollout crosswind weathervaned the aircraft and it rolled down the road bank into…Accident 20040226015159ATcraft BC12D · Wrightsville, AR(-23) On February 26, 2004, approximately 1800 central standard time, a Taylorcraft BC12-D, single-engine airplane, N43005, operated by a Private individual, was destroyed when it impacted terrain following a loss of control in flight while in the landing…Incident 20040226008549IMooney M20J · Sussex, NJ(-23) While attempting to land on runway 03 at the Sussex Airport, the aircraft "ballooned" after the first touchdown. The pilot stated he pulled back hard on the yoke and felt the aircraft stall. He stated the aircraft landed hard on the nose. As a result,…Incident 20040226006799IBeech D35 · Aberdeen, SD(-23) On February 26 at 11:05 am CST a Beech D-35 owned by bonanza management LLC of Aberdeen, SD lost power during an approach to land at Aberdeen, SD airport runway 17. VFR weather conditions prevailed at the time and no flight plan was filed. The aircraft…Incident 20040226004659IAmtr VELCITY173RG · Baco Raton, FL(-23) On February 26, 2004 at approximately 1804 local time, aircraft N173DT, a pollockmicheald/velocity 173RG s/n 001, landed on runway 23 at the Boca Raton Airport (bct). It was reported by the pilot, Mr. Paulo gold, that upon landing the nose gear caster…Incident 20040225010649IMooney M20K · San Antonio, TX(-23) On February 25, 2004, at approximately 1400 hours, a Mooney-20-K owned and operated by paul kortopates of san diego, CA, landed gear up on runway 30R at San Antonio airport. The pilot neglected to put the gear handle down after performing a maintenance…Incident 20040225007769ICessna 172E · Ravenna, OH(-23) Upon landing rwy 9 touched down (l) main gear, as (r) main and nose wheel made contact cross wind increased from (l). Aircraft started to veer (l) leaving rwy into muddy grass - tipping (r) and forward striking (r) wing tip and prop.Incident 20040225005069ICessna P206D · Soldotna, AK(-23) Returning from a hunting trip the pilot checked the weather and NOTAMS for the airport, noting a local NOTAM for "braking action nil". This NOTAM had been in place for most of the winter because the airport did not sand the runway. When the pilot…Accident 20040225003549ACessna R182 · Elberfeld, IN(-23) On February 25, 2004, about 1636 eastern standard time, a Cessna R182, N5450T, piloted by a commercial pilot, sustained an in-flight fire during its cruise flight near Elberfeld, Indiana. The pilot performed an emergency landing and the fire destroyed…Accident 20040225002889AFrchld SA227DC · Rifle, CO(-23) Aircraft landed approximately in last 1/2 to 1/3 of runway length for runway 26 at Rifle, Colorado, due to speed of aircraft it hydroplaned on wet runway even though there was no standing water. As aircraft slowed it started a shallow left turn and…Incident 20040225002619ICessna 310A · Dayton, OH(-23) On rollout after landing, rwy 6R, right main gear collapsed. Aircraft departed the runway to the right. No injuries. No fire. Minor damage.Incident 20040225001689ICessna T337G · Palm Springs, CA(-23) The landing gear failed to fully extend during approach to psp. The pilot tried emergency extension procedures. Tower gave the pilot a holding pattern to work the emergency. He determined that the hydraulic system was too low or depleted, so he put some…Incident 20040224007899IEMB EMB145XR · Buffalo, NY(-23) On February 24, 2004, at 1035 pm EDT, an Embraer 145XR, N13124, flight 3359, operated by Continental airlines express diverted and landed on runway 5 at Buffalo international airport after reporting a spoiler light indication. Fire and rescue responded.…Incident 20040224006719IAmtr STOL701 · Exeland, WI(-23) On February 24, 2004, at 1722 CST an amateur-built weatherhead, zenith stol CH701, N861SD, struck and severed an electrical power wire and landed on state road 48 in Exeland, WI. The recreational rated pilot was not injured and the aircraft received…Incident 20040224005239ISocata TB20TRINIDAD · Baltimore, MD(-23) Pilot was preparing to land at bwi, when he contacted tower to report a problem with the landing gear. Pilot made a low pass by the tower to confirm all three gear were down. The tower confirmed sighting of three gear. The pilot landed on runway 33R.…Accident 20040224003689ASaab 340B · Detroit, MI(-23) Aircraft N420XJ is loaded and being pushed back from gate C22. At the yellow line the wing walker gave the stop sign, but the pushback operator kept going. The pushback operator stated wing walker stopped at the line and was to the left and behind him.…Accident 20040224003259APiper PA20 · Laurel, MT(-23) At approximately 0800 hours local, the student pilot was conducting his second landing on his first supervised solo. After touchdown, the student pilot lowered his flaps and drifted right of the runway centerline. He attempted to correct his drift with…Accident 20040224003129ACessna 152 · Spencer, MA(-23) During a local flight the pilot lost power for about 3-4 seconds. The power returned but only at about 10-20 seconds before it lost power again. The power came back and then N4669L lost power for the final time. The pilot landed N4669L in a field. On…Incident 20040224003049IEMB EMB145LR · Pittsburgh, PA(-23) On February 24, 2004, at 0859 EST, an Embraer 145LR, N834MJ, operated by mesa airlines (masa), as us airways express flight #2989, declared an in flight emergency shortly after takeoff from Pittsburgh international airport (pit), Pittsburgh,…Incident 20040224003009IBoeing 737347 · Salt Lake City, UT(-23) The pilot reported that while executing a left turn onto runway 34R, a bang was heard. The cockpit crew elected to taxi off the runway and have maintenance inspect the aircraft. It was found that the left nose wheel had broken off. The passengers and…