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 20070317832179AAmtr Sonerai · Ft Atkinson, WI(-23) On March 17, 2007, at 1420 CST, a Sonerai iil, made an emergency landing shortly after departing from Ft Atkinson, WI airport. At about 300AGL engine started losing power. The pilot stated that he saw an area of trees that he did no think he would clear…Incident 20070317006779ITcraft BC12D · St Paul, MN(-23) On landing rollout pilot applied brakes, left brake did not release due to a mechanical malfunction making aircraft pull to the left and caused the aircraft to tip onto its nose causing a propeller strike with the ground.Accident 20070317006249AAmtr Longez · El Cajon, CA(-23) The airplane veered off of the runway after landing and the left landing gear to fuselage attachment was substantially damaged when the aircraft got into soft dirt. The pilot stated that just after touchdown, the airplane swerved left but he was unable…Incident 20070317005219ISalado, TX(-23) While skydiving in formation, a parachutist collided with a second parachutist, striking him in the chest with his head, temporarily disorienting himself. The parachutist released his main chute and deployed his emergency chute too close to the ground.…Accident 20070317005159ABell 47G2 · Meridinville, AL(-23) Pilot stated that he had a loss of power and autorotated into a soft field for landing. The aircraft skids sank into the soil and caused the aircraft to rock foward allowing the rotor blades to impact the ground which caused the transmission to come…Incident 20070317004969IDhav DHC6200 · Dublin, GA(-23) 10 Skydivers had exited two aircraft. With chutes open and descending through about 500' two of the skydivers were maneuvering to a traffic pattern for landing. One made a 270 degree turn and the other a 90 degree turn and collided. The chutes of both…Incident 20070317004909ICessna 210D · Nashville, GA(-23) PIC was on an IFR flight from crg to monroe, Mississippi. At 6000' over (4J2) Nashville, GA the PIC experienced a complete engine failure. PIC declared an emergency with ATC. PIC attempted to restart engine with no success. An emergency landing was…Incident 20070317004899IPiper PA28180 · Gibsonton, FL(-23) On March 27, 2007, at approximately 1015 EST, a Piper archer, PA-28-180, N32426, serial number 28-7505059, landed in an open field in Gibsonton, Florida after the engine lost power due to fuel depletion. The aircraft had departed from opa locka, Florida…Accident 20070317004049ABeech 58P · Marietta, OK(-23) At approximately 1410 on March 17, 2007 N584DP was destroyed while making a landing at the Mcgehee Catfish Restaurant near Marietta, OK. The aircraft landed short and very hard. The right strut fractured and was ripped from the aircraft. The right prop…Incident 20070317003329IPiper PA28R201 · Salt Lake City, UT(-23) On Saturday March 17, 2007 at approx 1040 MDT, a Piper PA-28R-201, N850NC, while performing touch-n-gos to rwy 16, the propeller struck the pavement and the aircraft was minorly damaged at Salt lake muni 2 (U42). The aircraft was being operated for…Incident 20070317003219IPilats PC1245 · Salt Lake City, UT(-23) On Saturday March 17, 2007 at 0507 MDT, an air methods corp (qmla) Pilatus PC-12-45, N399AM, piloted by [privacy data omitted] , with 3 medical personnel aboard, departed Salt lake intl (slc) on rwy 35. During take-off roll the aircraft struck 3 taxiway…Accident 20070317003199AMooney M20B · Saint George, UT(-23) On Saturday March 17, 2007 at approx 1745 MDT, a Mooney M20B, N74503, s/n 1814 departed st. George, UT (sgu) for mesquite, NV (67L), the aircraft made a normal departure via rwy 16. The aircraft was piloted by the owner [privacy data omitted] , and one…Accident 20070317003099ACessna 500CESSNA · Beverly, MA(-23) On an IFR GPS approach with a 500 ft ceiling to rwy 16 bvy aircraft landed hard and appeared to go sideways on the runway, tower asked PIC if everything was alright with the pilot replying "yes, why you ask." ATC then informed them that the right wing…Incident 20070317002809IMooney M20A · Hondo, TX(-23) Gear lever (handle) broke off in the pilot's hand as he attempted to lower the gear. The gear became disengaged but was not fully extended. Pilot went around and landed on grass strip parallel to runway 17L. There were three boy scouts onboard. There…Accident 20070317002729APiper PA28151 · Lincoln City, OR(-23) White PA-28-151 with blue and red striping was seen attending S45 (glen eden, OR) fly-in pancake breakfast 5 miles south of Lincoln City, Oregon on morning of 3/17/07 then departed early afternoon. Witnesses provide that similar aircraft was seen…Accident 20070316006699ACessna 172S · Los Angeles, CA(-23) On March 19, 2007, the van nuys FSDO received a telephone call from a [privacy data omitted] of vista aviation at the Whiteman Airport in pacoima, California. [privacy data omitted] Stated that one of his aircraft, a Cessna 172, was operated without…Incident 20070316005649IRobsin R44RAVENII · Dorado, Puerto Rico(-23) The pilot was on training flight circling clockwise around one spot (approx. 300 ft to center, IAS 35 KTS, 40 ft AGL). The aircraft started to increase yaw rate to the right. The pilot applied left pedal to stabilize/stop the yaw rate with continued…Accident 20070316004579AAerovd L39C · Titusville, FL(-23) On Friday, March 16, 2007 at approximately 1443 EDT, N63925, a single-engine aero vodochody L-39C tactical jet trainer built in the czech republic, crashed during airshow maneuvering at Space coast regional airport, Titusville, FL. The pilot was…Incident 20070316004329IBeech 95C55 · Mesa, AZ(-23) Pilot stated late switching from from auxiliary to left main. Engine started to run roughly, switched back. Engine slowed markedly, yet was smooth in operation. Proceeded in for landing. Shortly while on final, engine started to develop normal power.…Incident 20070316003879IUtva UTVA66 · Afton, WY(-23) Pilot departed gillette, WY and landed at Afton, WY for fuel. Upon landing on runway 16 at Afton the aircraft turned sharply left on touchdown and impacted a small berm of snow at the edge of the runway, and flipped over. The aircraft sustained damage…Accident 20070316003589ACessna 172E · Pleasanton, KS(-23) The pilot was landing to the south, a crosswind existed and the aircraft began to drift. The pilot applied power to initiate a go around and struck a tree branch 20-30 feet in the air. The aircraft impacted the ground into the tree branches that…Accident 20070316003119ACessna 182 · Diamond Lake, OR(-23) Pilot received communication of sibling suffering medical emergency at eugene medical center, eugene, OR. He decided to utilize his aircraft, N6462A, to travel from domicile (klamath falls, OR) to eugene. He provides that he intended to personally fuel…Incident 20070315006109IPiper PA22150 · Dillingham, AK(-23) Bungee cord broke away from ski tip. Ski toe went into snow without pilot's knowledge. As aircraft was taxied across lake, the ski toe went down into the snow enough that it damaged the left main landing gear.Accident 20070315004479ARobsin R44RAVENII · Miami, FL(-23) On March 15, 2007, the private pilot [privacy data omitted] left opa locka airport (opf) approx 1500 in R-44 N196DM with one pax on board to view his property located at [privacy data omitted]. While turning to return to opa locka, pilot reported that…Incident 20070315002979IRaythn 390 · Reno, NV(-23) Flight tga 167 (N167DP) declared an emergency because of smoke in the cockpit. Landed safely at Reno tahoe int'l airport at 1650PDT. Troubleshooting the problem revealed that an adaptive flight display (collins p/n 822-1084-014) was overheating and…Accident 20070314832139ACessna 172E · Big Rapids, MI(-23) Solo student pilot attempted a simulated soft field takeoff on rwy 32 at krqb. Aircraft drifted off the left side of runway and struck a snow bank approximately 300 ft into the takeoff roll. Aircraft tipped up on it nose and rolled over on its back…Accident 20070314007479APietsc IT · Douglas, AZ(-23) During practice for an upcoming airshow, the right rudder pedal turnbuckle came apart separating the rudder cable from the rudder pedal. This left the pilot with no control of the rudders or tailwheel once on the ground. During landing rollout, the…Incident 20070314006799ICessna 421C · Champaign, IL(-23) Aircraft enroute from dupage, IL to columbus, oh and had just leveled at 19,000 feet. Pilot had just reduced to cruise power when left engine started running rough. Pilot noticed smoke coming from left engine cowling. Pilot declared an emergency,…Incident 20070314005829IPiper PA34200 · Fort Myers, FL(-23) On March 14, 2007 at 0800 hours eastern daylight time, a Piper PA-34 airplane, N25PA, registered to four star flight training, palm coast, Florida and operated by the pilot [privacy data omitted] part 91, had a prop strike upon landing at Page Field…Incident 20070314004799IYaklev YAK52 · Nashua, NH(-23) On March 14, 2007, at 0958 eastern daylight time, a YAK-52, N52YB, received minor damage when the aircraft landed on runway 14 without the landing gear extended at Boire Field, located in Nashua, NH (ash). The certificated private pilot did not receive…Accident 20070314003449APiper PA30 · Paris, ID(-23) On March 14, 2007 at 2040 MDT a Piper PA-30-30, N7169Y, s/n 30-190, crashed while attempting to make an emergency landing at Bear lake co airport (1U7). The aircraft was substantially damaged, there were 2 minor injuries. The part 91 flight departed on…Incident 20070314003209ICessna 680CE · Lincoln, NE(-23) N308QS, CE680, was operated by net jets aviation inc., on a repositioning flight from st. paul, MN to Lincoln, NE. Thirty five miles north east of Lincoln, NE the crew reported to approach control that they had an indication of an anomaly with both…Accident 20070313012479ANamer SNJ5 · Pueblo, CO(-23) While taxiing the SNJ-5 aircraft using the "s-turn" procedure, the pilot [privacy data omitted] taxied across a glider wing that was not seen by the pilot [privacy data omitted]. Pilot's statement: after landing on runway 8L, I turned onto taxiway e,…Incident 20070313006759IPiper PA60601P · Akron, OH(-23) Upon landing pilot stated he had three green and landed mains touched down, and when the nose touched down it collapsed, resulting in nose gear door and nose skin damage. It is unknown at this time why the nose gear collapsed. Waiting on insurance…Incident 20070313004789IBeech B24R · Jacksonville, FL(-23) Aircraft porpoised on landing and struck hard on the nose gear. The nose strut housing broke and the nose of the aircraft settled on the runway. Damage is limited to the nose gear, lower cowl, prop, and small tear in fuselage skin.Accident 20070313003749ACessna 182H · Phoenix, AZ(-23) Aircraft engine failed to operate while in cruise flight due to fuel starvation. On attempted power off emergency landing on a road, the right wing struck a roadside traffic sign about two feet from the outboard wing tip causing substantial damage to…Accident 20070313003739AGrob G103TWNASTIR · Pueblo, CO(-23) While waiting to taxi his power glider (N39810) the pilot [privacy data omitted] was run over by a north American SNJ-5 (N12KY) and damaged the wing of N39810.Incident 20070313003699IUltralight · Berryville, AR(-23) On March 13, 2007, at 1330 CST an Ultralight owned and operated by the pilot [privacy data omitted] received substantial damage during take-off when the engine started leaking oil and made a forced landing at the end of the take-off runway at Berryville…Accident 20070313002959ABeech A23A · Holman, NM(-23) On March 13, 2007 at approx 1600 MST, a Beech BE-23, N4761J, registered to azusa lp of farmers branch, TX, collided with terrain during an off airport landing near Holman, NM, during a cross-country flight. Visual meteorological conditions prevailed at…Accident 20070313002769ARobsin R22BETA · Denver, CO(-23) On March 13, 2007 at 1615 MST a robertson R22 registration number N7681H was operating FAR part 91 flight instruction when during autorotation training the helicopter landed hard. Instructor reported that on a full down autorotation demonstration he had…Accident 20070313002749AAerosp SA315B · Norwood, CO(-23) A bird struck the tail rotor blades of the aircraft in cruise flight. No corrective action planned.Incident 20070312825999IBoeing 747212B · Dubai, TC(-23) On March 12, 2007 kcsa aircraft N703CK flight number K4-208 departed Dubai international airport, using runway twelve (12) destination brussels. Departure was normal with no pilot difficulties reported. Upon arrival in brussels it was discovered that…Accident 20070312004539ABlanca 1730A · Belmar/Farmingd, NJ(-23) On Monday, March 12, 2007, N404CT landed at atlantic city, new jersey (kacy). The owner of N404CT ordered 40 gallons of fuel from the local fixed base operation (FBO) at kacy. The owner requested one of the passengers on N404CT to monitor the meter…Accident 20070312003779APiper PA38112 · Groveland, CA(-23) On March 12, 2007 a Piper PA-38-112 tomahawk N2489P was attempting to land on runway 27 at Pine Mountain Lake Airport Groveland, CA (E45) at about 1000AM. The pilot [privacy data omitted] landed about halfway down the 3600 foot runway and skidded off…Accident 20070312003419APiper PA24400 · Des Moines, IA(-23) Pilot called dsm ATCT declaring an emergency due to unsuccessful attempt to lower gear. Aircraft landed gear-up.Incident 20070312003149IAirbus A320211 · Las Vegas, NV(-23) Flight 547 to cyyc departed the gate weighing 69,000 kg, 140 passengers plus 1 infant, and 10,900 kg of fuel. The longest runway was requested for take-off (25R). Crew were handed over to ground control prior to spot 11 and they were cleared to taxi via…Accident 20070312003089AHughes 269C1 · Plymouth, MA(-23) At approximately 0820 EDT on 03/12/07 the pilot [privacy data omitted] and [privacy data omitted] were performing a rotating pedal turn to the right at 3-6' AGL. About a quarter way through the turn they experienced a violent spin to the right and the…Incident 20070312002529IBombdr DHC8402 · Portland, OR(-23) On March 12, 2007 at 1430, horizon air, qxea, aircraft N409QX was parked at gate A6 at Portland International Airport (pdx). After the 74 passengers were on board the pilot selected the APU start switch to start the APU. Seven seconds after that a loud…Incident 20070311007759IUnivar 108 · Yuba County, CA(-23) Engine quit running while on a personal 91 flight. Made an emergency landing at beal air force base. No injuries or damage to the aircraft.Accident 20070311006169ACessna 172R · Columbus, OH(-23) Sunday March 11, 2007 at approximately 1543, aircraft N440ES, a Cessna model 172R attempted to land at osu airport. The aircraft veered off the left side of runway 27L entering the grass, striking several runway signs before stopping.