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.
Accident 20040910022549AAmtr GLASTARGS1 · Hayward, WI(-23) After taking off south from scott lake of the chippewa flowage near Hayward WI the aircraft encountered a wind gust which caused the aircraft to veer to the right. The pilot responded with full left aileron. When the pilot realized the aircraft was not…Accident 20040910022479ACirrus SR22 · Park Falls, WI(-23) The aircraft left sheboygan, WI between 0930 and 1030 with an intended destination of duluth, MN. It is believed that PIC gerald miller was receiving flight instruction from flight instructor byron oyster during this flight. It appears that the aircraft…Incident 20040910021899IBeech 58 · Kahului, HI(-23) Airplane leveling out at 3,000 MSL and selected cruise power. Pilot noticed the left engine tachometer spooling down, zero oil pressure, and increase in cylinder heat temperature. Pilot feathered the engine and declared an emergency back to Kahului…Incident 20040910021709IRobsin R22BETA · Hartford, CT(-23) The helicopter was running at full operating power, with the controls fractioned down, on the taxiway at hfd for the purpose of off-loading the left seat passenger at the conclusion of a photo-flight. As briefed by the pilot, the passenger exited the…Accident 20040909030389APiper PA32260 · Kennesaw, GA(-23) On September 9, 2004 at approximately 11:05 EST, aircraft N45100 departed cobb county-mccollum field (ryy) on runway 27 headed to saint lucie co intl (fpr) airport. Onboard the aircraft was a PIC, one passenger and cargo. On climb out the aircraft was…Accident 20040909026109APiper PA32R300 · Encino, TX(-23) The aircraft was operated by san antonio Piper inc. (MMPA488G) as a CFR part 135 on demand cargo and was IFR enroute from san antonio Stinson (ssf) to mcallen, Texas (mfe). Near falfurrias, Texas, the pilot advised houston center that he lost the vacuum…Accident 20040909026079ACessna T182T · Lake In The Hil, IL(-23) On September 9, 2004, at approximately 1215 CDT while landing at lake-in-the-Hills, IL, the private pilot impacted the runway with the nose gear, causing the nose strut to shear an attach bolt, bend the lower firewall, and damage the three propeller…Incident 20040909025609ICessna T210M · Concord, NC(-23) Due to the right landing gear failing to extend the decision was made between the company and pilot that a gear up landing would be the best course of action. The airplane received minor damage due to the gear up landing. On inspection it was discovered…Incident 20040909025169IPiper PA28181 · Dwight, IL(-23) Mr. Bradley peterson, PIC of PA-28-181, N1959H, lost control of the aircraft during a landing attempt on runway 9 at dgt. The aircraft sustained minor damage to the nose gear. The PIC and the 3 passengers of N1959H were uninjured.Incident 20040909023909IPiper PA31350 · Sidney, NE(-23) Mr. Hall tried to depart and the left engine quit and the right engine was running rough. He taxied back to the fixed base operation. The field elevation is 4313 feet mean sea level (MSL). The temperature was 33 degrees c, or 92 degrees f. the density…Incident 20040909021729IAmtr Cozymkiv · Chino, CA(-23) Mr. Herzstein landed his cozy iv aircraft on cno rwy 26R nose gear up.Accident 20040909021209APiper PA28140 · Mt Pleasant, SC(-23) On September 9, 2004, at 2150, eastern daylight time, a Piper PA-28-140, N9621W, collided with a deer on take-off from runway 17, MT. Pleasant airport (8S5) in mt. Pleasant, SC. The commercial pilot and passenger were not injured. The airplane was…Incident 20040909019649IRaythn HAWKER800XP · West Mifflin, PA(-23) On September 9, 2004, a Hawker 800 xp, s/n 258478, registered as N800DR was climbing from FL 290 to FL 310 while enroute from richmond Virginia (ric) to green bay Wisconsin (grb). During the climb, the crew reported an audible bang followed by strong…Accident 20040908034889ADoug MD900 · Mesa, AZ(-23) Helicopter taxied from parking at Boeing Mesa airfield. It then performed several hovering maneuvers for approx. 10 minutes in the helicopter active runway area. The pilot then landed on helipad #3 for a short time to contact tower for take off…Incident 20040908032779ICessna P210N · Payson, AZ(-23) Turbocharger induction air hose failed at inlet, resulting in loss of power at altitude. Pilot made emergency/precautionary landing at Payson Airport.Incident 20040908032769IBeech 95A55 · Oceanside, CA(-23) In a telephone interview, the pilot stated that on approach for landing at Oceanside, CA (L32), he noticed an aircraft on the runway and executed a go-around. He then discovered that he was at the carlsbad airport (crq) and not Oceanside. He was advised…Accident 20040908031189ACessna 402C · Charleston, WV(-23) Aircraft departed on runway 33 when the pilot noticed the forward left baggage door open. The pilot reported that he aborted takeoff with approximately half the distance of the runway remaining (2,375 feet). The aircraft slid off the end of the runway…Incident 20040908025399IBeech C90A · Gulf Shores, AL(-23) On September 8, 2004 Mr. Don vaughn pilot of accident aircraft landed at Jack Edwards Airport when the right main landing gear collapsed. The pilot stated that prior to landing the gear down and lock indication was in the green. At approximately 3500…Incident 20040908024649IGrob G102ASTIR · Cherry Valley, AR(-23) Mr. Luebke was towed from Cherry Valley for a solo flight about 3 miles north of the field. Mr. Luebke was released from the tow plane and started his maneuvering at 3000 feet. He flew into a 10 knot sink and could not make it to the airport. Mr. Luebke…Incident 20040908023619IAmtr SCORPION2 · Tucson, AZ(-23) The instructor and student had been in a hover approx. 20 minutes, two(2) feet off the ground, when a loud noise was heard in the transmission compartment behind them and a subsequent loss of main rotor drive. A routine "hovering autorotation" was…Accident 20040908020889ABeech B60 · Casper, WY(-23) Aircraft was taxiing in from the main runway when the nose gear collapsed. Further investigation revealed that a bolt was missing from the nose gear down lock system. Nose gear maintenance had been performed 1.8 hours before accident.Incident 20040907030999IEMB EMB135LR · Roanoke, VA(-23) While in cruise-descent to FL210, right after the "eicas" "icing" caption illuminated, the cockpit and cabin filled up with smoke and soot. The captain declared an emergency, and landed uneventfully in roa, VA. The oxygen masks were not deployed, and…Accident 20040907024839ACessna 170B · Nome, AK(-23) [privacy data omitted] after taking off from the gravel bar the aircraft failed to clear an embankment at the end of the gravel bar. The aircraft's propeller struck the embankment first and then the landing gear. During the impact the right main gear…Incident 20040907024509ICessna 421C · Stockton, CA(-23) Pilot garrison was operating the aircraft in part 91 operation, having departed sac for direct flight to palm springs, CA. At FL 170, pilot reported the right hand windshield segment ruptured suddenly. The resulting depressurization partially fractured…Incident 20040907023759IMooney M20J · Sand Springs, OK(-23) Pilot departed (4FT) westport, OK, enroute to pick up his wife at Sand Springs, OK (0F8). On final approach to land, pilot began his flare at which time he heard what he thought was his gear horn for not having the gear down and locked. He reached over…Accident 20040907020949ACessna 180H · Dixie, ID(-23) N3458Y, a Cessna 180 aircraft received substantial damage upon landing at Wilson bar airstrip located on the salmon river in central Idaho. Mr. Jesse stone, a private pilot owns, and was acting as pilot in command on the aircraft on September 7, 2004 at…Incident 20040906034469IBell 430 · Philadelphia, TN(-23) The pilot and crew of the EMS helicopter responded to an on-scene flight for patient pickup in a field beside a state highway. After a high recon to identify hazards the pilot began an approach to the landing area. On final approach the pilot noticed…Incident 20040906034359ICessna 172M · South Kortright, NY(-23) A/c landed slightly long on wet grass. Pilot noticed a muddy area at the end of the r/w and shut off the engine. A/c main Landing gear stuck in the mud and the a/c flipped over. There was no damage to the a/c and no injuries to the pilot. This matter is…Incident 20040906033519IBbavia 7AC · Schenectady, NY(-23) On final approach to ksch, PIC made slight input to the left rudder to stay aligned with the runway 22. Just prior to touching down, a strong gust from the left picked up the aircraft approximately six feet from the ground. PIC attempted to level the…Accident 20040906026479ACessna 172S · Mount Gilead, OH(-23) The student pilot, in the left seat, was flying the aircraft on approach to runway 10 in a right crosswind. According to a witness, the left wing tip struck the ground short of the runway turning the aircraft to the north. The certificated pilot, in the…Incident 20040906025939IPiper PA32R300 · Bloomington-Nor, IL(-23) IFR at 10000 from hhg to gph with peoria, IL ATCT pilot declared an emergency due to odor in cockpit. Aircraft diverted to bmi where an uneventful landing was made. Pilot removed the top cowling and found no evidence of leakage or burning. Aircraft was…Accident 20040906025739ABeech E18S · Tullahoma, TN(-23) With ten skydiving jumpers on board, on take-off roll, 180' crosswind from the left with the tail coming up, the right MLG tire flat, left wing came up. The airplane forced to the left so shut down the power. The airplane went left and right wheel…Incident 20040906025209ICessna 182B · Bainbridge Isla, WA(-23) Pilot reported that while in cruise flight he lost part of the cowling on the nose gear door over the water near Bainbridge island WA.Accident 20040906024299APiper PA22160 · Kenai, AK(-23) During takeoff roll from bishop beach, AK aircraft N9028D veered to the right, the pilot tried to correct by use of left rudder. The aircraft struck the left wing tip then flipped onto its top.Accident 20040906022929ACessna 180 · Buena Vista, CO(-23) On September 6, 2004 a Cessna CE-180, N727DG landing runway 33, 7V1 Buena Vista ground looped shortly after touch down. The PIC holds an ATP rating and was not injured. Winds were reported at 350 at 5 knots, however the pilot stated he entered a gusty…Accident 20040906022139AMooney M20D · Pagosa Springs, CO(-23) On September 6, 2004 N1907Y a Mooney 20D departing runway 19, 2V1 Stevens field, Pagosa Springs impacted the ground and burned. The PIC sole occupant on board received fatal injuries. FAA database indicated the pilot had a total flight time of 2600…Accident 20040906021109APiper PA18 · Healy, AK(-23) PIC stated that during downwind/downslope takeoff from gravel-bar he lost control and aircraft tipped forward onto its back damaging the rudder and elevators.[privacy data omitted]Accident 20040906020939ACessna 182B · Gillette, WY(-23) While in cruise from casper, WY to Gillette, WY, the engine started to run rough. The pilot turned the magnetos off due to the engine making a very loud mechanical sound. The aircraft landed in a field, hit a fence and flipped upside down after the nose…Incident 20040906020689IPiper PA32R301T · El Cajon, CA(-23) On September 6, 2004 N4139V, a Piper aircraft model PA-32R-301T departed an unimproved dirt strip in rancho el barril, Mexico, direct Gillespie field (see) san diego, CA. During the take off roll the pilot stated the aircraft struck a pothole/object,…Accident 20040905035379APiper PA32300 · Montauk, NY(-23) Aircraft attempted to land rwy 6, struck tree tops 200 feet from displaced threshold. Aircraft's left wing struck tree-top, aircraft turned 90 degrees to the north and continued to travel toward the runway. Aircraft broke through fence, traveled across…Incident 20040905032039IChris A1 · Manitowish Wtrs, WI(-23) The pilot was making a high speed taxi on rest lake, Manitowish waters, WI. The pilot reported the winds was less than 10 knots. He noticed there was few waves ahead possibly caused by a boat wake. He pulled back the power and held the stick back went…Incident 20040905027209IAmtr SNS7 · Warrenton, VA(-23) The aircraft landing gear collapsed after landing on a private grass strip. The pilot was not injured and he was the only occupant. The aircraft received damage to the left wingtip, landing gear and propeller.Accident 20040905026929AScwzer G164B · Penn Yan, NY(-23) On 09-05-04, at approx. 1900 EDT, a Schweizer G-164B aircraft with registration N7501H conducted a normal landing at Penn Yan NY. During the landing, the aircraft received substantial damage when the right main wheel structure failed and the pilot could…Incident 20040905023679IDoug DC3A · Laredo, TX(-23) Pilot was conducting first flight since operating in accordance with 125 deviation issued by sat FSDO. When approximately 50 miles north of Laredo, TX, the #2 (r/h) engine lsot power and pilot declared an emergency with houston center and returned to…Accident 20040905023519ARobsin R22BETA · Las Vegas, NV(-23) On September 9, 2004, at approximately 1020 local time, N994RW (Robinson R-22 helicopter) crashed and was destroyed while practicing 180 degree autorotational descents to power recoveries. The pilot-in-command (qualified flight instructor), andrew r.…Accident 20040905023029AAmtr COMPAIR7SL · Canon City, CO(-23) While making an approach into 1V6 Canon City, CO, about 15 feet from touchdown, a strong gust of wind came out of the southwest and blew the aircraft off centerline with right wing high. The pilot leveled the aircraft, but his RPM was too slow for a…Accident 20040905022089APiper PA18150 · Cantwell, AK(-23) On September 3, 2004 about 1900 Alaska daylight time, aircraft N9796P, a Piper PA-18-150 was destroyed by fire following a forced landing about 25 miles northeast of Cantwell, Alaska. The solo pilot received minor injuries. The flight departed the…Incident 20040905021929IPiper PA18 · Homer, AK(-23) RH rudder interconnect cable, from pilots rudder pedal to copilots rudder pedal separated at pilots RH rudder connect tab during takeoff. PIC retained control of aircraft through aileron control. Passenger in rear seat had control of rudder through rear…Accident 20040905021489AMooney M20F · Flowood, MS(-23) During cruise flight at 10500 feet, east of jan the engine began to run rough. Shortly thereafter the pilot executed an emergency landing and during landing roll collided with a pickup truck. No injuries to either parties. Number 3 cylinder separated…Accident 20040905021179APiper PA32R301T · Picabo, ID(-23) Aircraft started takeoff to the west at Picabo Airport, Idaho. The private pilot in the left seat, who initiated the takeoff, thought that he was being instructed by the instructor pilot in the right seat. Pilot in the right seat claims he did not know…