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 20090629010189IMooney M20J · Monroe, NC(-23) While receiving instruction by the CFI in the right seat of N205RW, the student pilot made a gear up landing on runway 23 at the Monroe regional airport. The student pilot did not extend the landing gear and the CFI did not verify the landing gear…Accident 20090629009809AAirtrc AT602 · Knobel, AROn June 29, 2009, at approximately 1859 CDT, N5192T, a AT-602, was operating a FAR 137 agricultural aircraft operation, near Knobel, Arkansas. The commercial pilot reported the loss of power while executing a turn. The pilot made the decision to make an off…Accident 20090629009559ASphrth VENTUS2CM · Parowan, UT(-23) On June 6th, 2009 at approximately 2030Z [privacy data omitted] piloted N68MP at a glider competition in parown, UT. The glider had a self contained engine that was ot operating correctly, so the pilot operated to store it and be towed into the air. The…Incident 20090629008309IAmtr RV10 · Shawnee, OK(-23) The nose gear assembly retaining nut, washers, and cotter pin worked themselves off at some time prior to takeoff. Upon takeoff the nose gear assembly came off the strut, coming to rest on the runway. The washers were located on the taxiway, retaining…Accident 20090628047389ACessna 152 · Mt. Pleasant, SCStudent pilot was landing on runway 35 at Mt. Pleasant airport, (lro) near charleston, SC. The airplane bounced 3 times, the pilot added power and the airplane nosed over and then went off the left side of the runway. While leaving the runway, both wing tips…Incident 20090628025859IBeech 200 · Anchorage, AKPilot (capt) reported that during cruise at 23000 feet MSL near mount redoubt, he heard a loud bang. The co-pilot (SIC) saw that the right hand over-wing locker had departed the aircraft. Crew declared an emergency and continued to the ted Stevens…Accident 20090628016789AChampi 7GCAA · Shelbyville, INWhile practicing engine failure procedures the, pilot in command (PIC), IN the rear seat, lost control of the aircraft and crashed into a soybean field. The PIC alleges that when he applied power to recover from the procedure at approximately 150 ft above…Accident 20090628012579ACessna 172M · Rimrock, WA(-23) Airman attempted a landing at an unimproved landing strip, that is considered a one way runway. While accounts vary as to how close the aircraft came to the runway, it is nonetheless clear that the aircraft did not actually land, but instead attempted a…Incident 20090628012049IAmrgen AA5B · Bixby, OK(-23) [privacy data omitted], and his son [privacy data omitted] departed from riverside airport (rvs), tulsa Oklahoma towards okmulgee, Oklahoma. At approximately 2,200 feet the aircraft started to stutter together with progressive power and altitude loss.…Incident 20090628011099IRaythn G36 · Houston, TX(-23) In a statement by the PIC and witnesses on the ground, during a local pattern flight, at the point of touchdown during landing the PIC heard a loud bang or pop from the vicinity of the nose landing gear area and simultaneously received a gear warning…Incident 20090628010929ICessna 172RG · Spokane, WA(-23) Pilot was landing at geg on runaway 25. Winds were 6 to 8 knots @ '170 degrees. Aircraft porporised on landing and the pilot did not react properly resulting in a prop strike on the runway.Incident 20090628009909IScwzer SGS126E · Lehighton, PA(-23) The student was solo, performing practice flights over the ridge. He lost thermals and was trying to make it back to the airport but landed short in a grassy field and clipped two small bushes, damaging the left wing.Accident 20090627857209AChampion 7GCAA · Ware, MA06/03/2010PER the pilot, [privacy data omitted] on 27 June 2009 at 1300 hrs I was flying back from turners falls airport (OB5), after a fresh annual and I was landing on my personal grass strip on my property, (uwa) runway 20, during approach, at approx 3…Accident 20090627047449ACessna 170A · Kasigluk, AKStudent pilot stated that as he was landing the wind picked up and caught the wing, he over controlled and pressed the left brake too hard, the aircraft left the runway, ground looped, and nosed over in a ditch.Accident 20090627013189ACessna 172P · Colorado Sprin, CO(-23) On June 27, 2009 at 11:30 MDT aircraft N52298, a Cessna 172P serial number 17274489 crashed while initiating a go-around after an aborted landing. According to the pilot while in flare to land, the airplane would not settle to the runway normally. When…Accident 20090627011749AAmtr Monsoon · Konona, NY(-23) On 06/27/2009 [privacy data omitted] a student pilot based at Konona airpark, Konona, n.y. took off from runway 33 in aircraft N308AA, an apollo Monsoon light sport aircraft, weight shift control to fly in the local area. [privacy data omitted] The…Accident 20090627011559ACessna 172D · Louisville, KY(-23) Aircraft departed Blue Lick (07KY) on a heading of 140 degrees and cruise altitude between 1700 to 1800 MSL. At which the aircraft loss power and the pilot made a emergency landing in a soy bean field. The result of the landing broke off the nose gear,…Incident 20090627011309ICessna 206 · Brooklyn, IA(-23) Shortly after take-off, while climbing through two thousand feet, the engine "popped", began vibrating, and losing power. Pilot initiated an immediate turn upwind returning to the airport, and encountered a tail wind on final approach causing him to…Accident 20090627011229AAmtr ROTORWAY162F · Midlothian/Wax, TX(-23) The pilot stated that he was approaching the south side of taxiway where he planned to hover at 10 feet and fly to his hangar. During transition, he lost tail rotor effectiveness, and the aircraft impacted the taxiway, bounced, and spun. He was unsure…Accident 20090627010399AWaco YMFF5C · Pittsburg, KS(-23) On June 27, 2009, a private pilot and flight instructor were conducting a training flight in a Waco YMF-5C registered N702DB. One hour after the flight began, the instructor and student were practicing full stop landings on runway 22 at Atkinson airport…Accident 20090627009719AAircre Tanarg · Wilmington, CA(-23) At approximately 2500FT MSL, on final approach for runway 29L at torrance airport, engine quit without any warning. Restart attempted but unsuccessful. Pilot executed emergency landing on naval reservation with no injuries or damage sustained to…Incident 20090626047459IPiper PA-18-150 · Kaktovik, AKWhile landing on a gravel bar 15 miles sse of bti aircraft struck something with landing gear resulting in aircraft nosing over and incurring a propeller strike.Incident 20090626012239IBoeing 757222 · Pittsburgh, PA(-23) On June 26, 2009, at approximately 0823 eastern time, a Boeing, 757-222, conducted under 14 CFR part 121, flying from the chicago o’hare international airport (kord) to the baltimore/washington international thurgood marshall airport (kbwi), while at…Accident 20090626011809APiper PA32R300 · Osceola, MO(-23) On June 26, 2009, approximately 0904 central daylight time, a Piper PA-32R-300, serial number 32R-7780392, N38171 airplane, was destroyed when it impacted terrain near gaston's resort, lakeview Arkansas. The airplane was registered to propaire inc.,…Incident 20090626009879IPiper PA24250 · Rangely, CO(-23) During a cross country flight from denver, CO to vernal, ut the PA-24-250 experienced loss of power 40 minutes in to IFR conditions at an altitude of 11,000 feet, the pilot declared an emergency and landing uneventfully in Rangely, CO.Incident 20090626009669IBell 407 · Fort Worth, TX(-23) Instructor pilot for Bell training academy and FAA pilot where conducting autorotations aircraft landed short and aft cyclic was allowed to be applied, vertical fins and main rotor blades received damage due to this type of maneuver aircraft was flown…Accident 20090625047419AP & M Aviat Quikr · Cedartown, GAThe following are from eye witness accounts: the aircraft was flying at approximately 600 to 1000 feet above the ground, the right wing of the aircraft went down slightly at the same time the left wing went up. The aircraft then started to spiral 3 or 4 times…Incident 20090625047349IVittone Jos Velocity XL · Gulf Shores, ALLanding gear showed "unsafe" indication at extension for landing. Pilot requested assistance from other aircraft to determine gear position. Other pilot(s) reported gear was out and appeared to be locked. Main landing gear collapsed on landing rollout.Incident 20090625019479IConsol LAKEMODEL250 · Port Washingto, WIWhile enroutr from waukesha county airport (ues) to sheboygan county memorial airport (sbm) the pilot attempted a touch and go in lake Michigan about 3 miles east of Port Washington, WI. After landing, while taxiing the aircraft the right sponson struck an…Incident 20090625015669IAmtr RV9A · Cameron Park, CA(-23) According to the report filed by the el dorado county sheriff's office, the pilot of N4774L, reported to sheriff deputy she was attempting to land from the south (runway 31) at Cameron Park airport. At the point of flare, a big gust of wind pulled the…Accident 20090625013569ARobsin R44II · Lakeport, CA(-23) Engine died during instructional 180 autorotation resulting in hard landing with damage to the main rotor and tail boom.Incident 20090625011459ILear 35A · Denver, CO(-23) Metro airport received a lot of rain from a thunderstorm just prior to N549PA landing on runway 29L. After touchdown, the aircraft began to hydroplane. With no brake effectiveness, the crew deployed the aircraft's parachute. The airplane continued to…Incident 20090625011319IPiper PA31350 · Washington, PA(-23) The right engine experienced a decease in oil pressure and manifold pressure followed by erratic performance. The engine was secured as a precaution. Inspection by the operator's maintenance personnel found six broken attachment studs at the #3…Incident 20090625010999IPiper PA28R180 · Cottage Grove, OR(-23) The PIC said he was concentraining on a perfect approach and forgot to put the gear down. The PIC said he mentally blocked out the gear horn because he was so focus on his approach. He said everything was working as it should in the aircraft with the…Accident 20090625010899ARobsin R22BETA · Clarkston, WA(-23) During loss-of-power autorotation to farmer's stubble field, main rotor severed tail assembly and helicopter turned on it's side. Severe damage to helicopter, no serious injuries to pilot or passenger.Accident 20090625010619AMaule M5235C · Dixie, ID(-23) On short final to runway 24, at an altitude approximately 20 feet AGL, the aircraft stalled and proceeded to bounce once, upon second contact with the ground the right gear collapsed and the right wing and propeller impacted the ground. After impacting…Accident 20090625010389APiper PA31T1 · St Louis, MO(-23) N701PT departed the end of runway 16 during landing at the Creve Coeur Airport and continued to travel for an additional 434 feet beyond the runway end. The aircraft penetrated a barbed wire boundary fence and came to rest 40 feet into a corn field. The…Accident 20090625010319AQuicks Mxiisport · Longmont, CO(-23) Student pilot was flying N2910P, practicing takeoffs and landings. Aircraft experienced an engine failure as a result of fuel starvation. Aircraft landed short of the runway on a public-use road and impacted a guardrail.Incident 20090625009659ICessna T210M · Salmon, ID(-23) On an air carrier flight from boise, ID (boi) to bozman, mt (bzm), the pilot experienced engine failure and made a landing on Idaho state route 28. The location is approximately on the Salmon VOR (lkt) 105 degree radial @ 30 NM. There were no injuries…Accident 20090625009639APiper PA25235 · Preston, ID(-23) On the morning of June 27, 2009 craig biggs, the pilot of N8600L was returning to the Preston, ID airport for his second load of chemical of the day when the engine quit on a base to final landing runway 03. The pilot made an emergency landing in a…Accident 20090624047399ACessna 210-5(205) · Porterdale, GAThe following facts are derived from the pilot and passengers written statements: the aircraft was enroute from VG58 to ffc. Approximately 5O miles from ffc, the aircraft experienced fuel depletion of the right fuel tank, followed shortly by fuel depletion of…Incident 20090624019459IBoeing 747132Crew reportedsmoke odor from a/c system, odor observed in zone 1, smoke oder stopped with flight deck fan turned off. Maintenance removed and replaced flight deck recirculation fan p/n 605457-1 per B747 m/m 21-25-06. Ops check good iaw B747 m/m 21-25-00. Ksca…Accident 20090624016129AHawker B95 · Holbrook, AZ(-23) On June 24, 2009, at approximately 1702 MST, a Beechcraft B-95 travel air, shortly after takeoff from Holbrook Municipal Airport (P014), Arizona, impacted the ground .43 miles from the end of runway 03/21, killing the four occupants. The pilot had a…Incident 20090624015789IBoeing 757232 · Ontario, CA(-23) Severe # 2 engine vibrations due to ice (FOD) ingestion.Accident 20090624012339AUnivar 1083 · Llano, TX(-23) On Wednesday, June 24, 2009 at approximately 11:10 am CST, the student pilot was conducting solo touch and goes at aqo lalano municipal airport, Llano, Texas. Witnesses stated that the aircraft made a very soft landing; however, the left wheel assembly…Accident 20090624011269AWeston Seaera · Redmond, WA(-23) While on final approach to landing at lake samammish, WA, the airacraft stalled at approximately 8 to 10 feet above the water. The aircraft struck the water left wing low causing substantial damage to the aircraft. The aircraft remained afloat while…Accident 20090624011209AHubbel Prescottpush · Columbus, OH(-23) The pilot stated that while on descent into klck from 6500 ft MSL to 1500 ft MSL the left hand leading edge of the canopy door started to flutter followed by the canopy door separating from the aircraft. The door made contact with the propelle causing…Accident 20090624011139AAmtr Mustangii · West Union, OH(-23) On June 24, 2009 at approximately 2030 local (EDT), Mr. Anthony schendl was fatally injured when he crashed his mustang ii. June 25, 2009 the crash site was investigated, the aircraft was destroyed. Witness stated that Mr. Schendl had been performing…Accident 20090624010889ACessna 152 · Oklahoma City, OK(-23) Student pilot was practicing slips to runway 17, landed long, bounced and upon final touchdown with approximately 1000' remaining proceeded to use maximum braking creating skid marks on the pavement. The aircraft departed the runway at the departure…Incident 20090624010839ICessna 140 · Gilmer, TX(-23) On June 24, 2009, at 1000 EDT, a Cessna 140, N76655, registered to the mechanic/pilot/operator: [privacy data omitted], ground looped while performing a high speed taxi at the gillmer airport (kjxi), gillmer Texas to test maintenance work performed on…