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 20090724012819AScwzer SGU222CK · Ephrata, WA(-23) During a prematurely initiated vehicle towed glider launch wherein the vehicle driver misunderstood signals, while the flight instructor was still in the process of getting ready to launch, the aircraft became airborne. During the excitement of the…Accident 20090724012789ASkrsky S55B · Chelan, WA(-23) During cherry-drying hover over orchard, lost hydraulic power, pulled and cleared orchard, selected near-by vacant field and executed precautionary landing. During running-on landing, encountered unseen large hole and made hard landing. Main rotor…Incident 20090724010519IMooney M20F · Hailey, ID(-23) The aircraft was enroute from sheridan WY (kshr) to Hailey id (ksun) at approximatelly 8500' and 22 miles se of Hailey id when a moderate engine vibration was detected by the pilot. Within 2-3 minutes the vibration became severe and the pilot declared…Accident 20090723047739AMaule M-7-235B · Turner, ME7/23/09 About 0930LCL N595Z a Maule M-7-235-B tookoff from THE12/30 asphalt runway at twichell's airport inturner me (3B5). At about 0931 the aircraft landed on the 2000FT grass runway down the hill next to the Twitchell's airport seaplane base. Towards the…Accident 20090723025299ATaylorcraft BC12-D · Tok, AKDuring takeoff on Alaska highway 2 at milepost 1303 the aircraft was substantially damaged when the left wing struck truck parked by the roadside.Accident 20090723020189ABeech C90A · Bismarck, NDOn July 23, 2009 at 1235 local time, a Beechcraft BE-C90, N405DD owned and operated by the university of north dakota sustained substantial damage during takeoff at Bismarck, ND. No injuries were reported to the crew of two or passenger on board the aircraft.…Accident 20090723017719AAmtr Flightstarii · Malta, ILOn July 23, 2009 at 1900 gmt with visual meteorological conditions, an experimental light sport aircraft, a crisman harry, model flightstar ii, N5008E, registered to marlin anderson was on a FAR part 91 personal flight. During the takeoff climb from a private…Incident 20090723015779IMooney M20K · Georgetown, CA(-23) Pilot failed to lower landing gear for landing.Incident 20090723015069IBeech A36 · San Diego, CA(-23) PIC, [privacy data omitted], was performing "touch and go" landings and takeoffs on runway 26R at Brown field, San Diego, CA. Upon landing with landing gear down, davenport began the transition for takeoff. He pushed the throttle to full power, then,…Accident 20090723014889ACorvus Coronemki · Lee'S Summit, MO(-23) The pilot stated that after takeoff from rwy 29, the engine momentarily lost power followed by immediate power restoration. While turning left crosswind, the engine backfire, surged and lost power. The pilot made a forced landing to a grass field.Accident 20090723013209APiper PA25235 · Miller, MO(-23) One of the ground crew was washing down the airplane while the engine was running, with the pilot in the airplane and at the controls, when he backed into the propeller arc and was struck three times by the propeller blades. He was seriously injured and…Accident 20090723012899ACessna 150H · Washougal, WA(-23) A pilot took off from his private airstrip near Washougal, WA. As the aircraft departed, a right turn was initiated. Witnesses recall seeing the aircraft striking the top of a 70 foot tree, loosing altitude while in a left bank, then disapearing upside…Accident 20090723012859ARobsin R44 · Smithsburg, MDOn July 23, 2009, approximately 1030 eastern daylight time (EDT), a Robinson R-44 helicopter, registration N7189W, registered to marsan aviation incorporated, operated by the advanced helicopter youth foundation was destroyed when it impacted power lines that…Accident 20090723012799APiper PA32R301T · Colorado Sprin, CO(-23) On Thursday July 23, [privacy data omitted] in N301RT, a Piper PA-32R-301T, attempted to depart cos on 17R. After receiving weather warnings of turbulent air near airport, [privacy data omitted] started his takeoff. At 90 KIAS, he lifted off the runway.…Incident 20090723012109IAmtr Cozy · Baton Rouge, LA(-23) Pilot explained that on approach to the btr airport, he was ratchiting down the nose gear in his Cozy, pilot got caught up in a conversation with ATC, and thought he had completed the ratchiting of the nose gear. Upon landing, the nose gear rolled back…Incident 20090723011929IAirtrc AT301 · Nebraska City, NE(-23) Air tractor 301, N3658C, piloted by mark a. warmack on July 23, 2009 was conducting a spraying operation south of Nebraska City airport. After making a couple of passes over the field, Mr. Warmack inadvertantly hit a power line on his third pass. The…Accident 20090723011609APiper PA28181 · Metaline Falls, WA(-23) [privacy data omitted] was the pilot of N2903A a Piper PA28-181. He landed at the Sullivan lake (09S) airport. His plan was to allow the aircraft to taxi after landing to the end of the runway. He landed to the north and was planning a departure to the…Accident 20090722047719ADehavilland Beaver U-6A · Iliamna, AKThe pilot departed downriver into what he believed was a light quartering headwind. During climb out the aircraft encountered a previously undetected tail wind, which negated relative forward speed and ascent, resulting in the airplane slowing and descending…Accident 20090722020009AAmtr RANSS6 · Santa Rosa, NMOn July 22, 2009 at 1230 MDT, N410BT, an amateur built rans S-6 piloted by a certificated sport pilot took off from runway 26 at Santa Rosa route 66 airport (sxu). The aircraft lifted off and rose a few feet into the air. Within seconds the aircraft stopped…Incident 20090722017929IScwzer G164A · Standley, ND(-23) ON JULY 22, 2009, AT 1745 HOURS, CENTRAL DAYLIGHT TIME (CDT), A GRUMAN G-164A, N6894q, OPERATED BY A COMMERCIAL PILOT, SUSTAINED MINOR DAMAGE WHEN THE AIRCRAFT HIT THE GROUND ON A HILL. THE AIRCRAFT ENGINE HAD LOST POWER BECAUSE OF A BLOWN CYLINDER.…Incident 20090722014559IAmrgen AA5 · New Smyrna Bea, FL(-23) On July 22, 2009, at approximately 1900 EDT, a gruman tiger, model AA-5, N7109L, serial # AA5-0409, departed ormond Beach municipal airport, ormond, Florida. The aircraft sustained minor propeller damage after an emergency landing on interstate 95,…Accident 20090722014469AHughes 369D · Uniontown, PA(-23) Pilot was performing geophysical seismic survey and was enroute to staging area for fuel. Aircraft crashed approximately one mile short of the staging area. The helicopter crashed and came to rest in an upright normal attitude with a slight lean to the…Incident 20090722014259IPiper PA28140 · Winnemucca, NV(-23) The student pilot received her endorsement to solo a PA-28-140 on 07-02-2009. While performing touch & go's the student pilot stated that "just before touching down on the runway I experienced an immediate lift that I believe was either a gust of wind…Accident 20090722014209APiper PA44180 · Long Beach, CA(-23) Pilot and passenger had filed a flight plan to depart klgb airport, during taxi, pilot in command made left turn and struck an orange marking cone causing damage to the left propeller. During the interview with pilot and passenger, the passenger…Accident 20090722012349APiper PA30 · Walla Walla, WA(-23) The pilot stated that he completed his checklist and was cleared to land. He said that he verified that the gear showed green but the sun was bright on the panel and the gear light may have looked like it was illuminated. There was no audio warning when…Accident 20090722012289AAmtr SA300 · Iowa City, IA(-23) Pilot had departed grinnell, IA enroute to long island, NY. Pilot reported engine problems in the Iowa City, IA area and tried several times to restart the engine with no success. Pilot made emergency landing on a street in a residential area of Iowa…Accident 20090722011629AMooney M20C · Elma, WA(-23) On July 22, 2009 at approx. 2:45 pm, N64422U, a Mooney M20C, s/n 2169, appears to have been piloted by the registered owner of a fire watch patrol, sustained substantial damage following an in-flight collision with trees, power transmission lines and…Accident 20090721048859ABell 206B · Goodman, ALThe accident occurred during a us army instructional flight. The aircrew was hovering to park when the pilot felt an uncommanded cyclic control movement to the left. The rotor blades contacted the ground before the pilot could regain control which resulted in…Accident 20090721018079ARobsin R22BETA · Jerome, AZ[privacy data omitted], Flight instructor, and [privacy data omitted], private pilot, were on a training flight in a Robinson R-22, N747ER. The flight originated at prescott municipal airport (prc). [privacy data omitted] Was doing a training flight in…Accident 20090721017989ABell 212 · Willow Creek, CA(-23) On July 21, a rappeller sustained fatal injuries from an un-arrested descent out of a helicopter from an altitude of approximately 200 feet. The accident occurred during rappel proficiency training. As the individual was moving into the rappel position…Incident 20090721014629IBoeing 737752 · San Francisco, CA(-23) *NLG collapsed during normal pushback procedure.Accident 20090721012779APiper PA46350P · Redmond, ORAircraft departed kdvo at 1200 (PDT) for a flight to S21. Flight was VFR with flight following services provided by ATC. While approaching sunriver, Oregon, panel landing gear down and locked indicator lights did not illuminate. Breakers were check and the…Accident 20090721011569AUnivar 1082 · Gardner, KS(-23) The pilot and sole occupant of the airccraft took off on a local VFR flight from runway 26 at Gardner Municipal Airport (K34) in Gardner, Kansas. On his initial takeoff and climb, at approximately 300 feet AGL, the engine lost power. He attempted to…Incident 20090720048359IPiper PA-25-235 · Bryan, OHIn an email statement dated 7/21/09, the [privacy data omitted], stated that on 7/20/09 during aerial application of chemicals he struck an electrical wire approximately 20 feet off of the ground. His airspeed at the moment of impact was 100 mph. After the…Incident 20090720047919IBeech 35-C33 · Groton, CTDuring climbout from a missed approach after a practice ILS to runway 5 the left fuel tank ran dry and the engine ceased operation. There was fuel remaining in the right tank. The pilot switched tanks but was unable to restart the engine in the time remaining…Accident 20090720020129AWthrly 620B · New England, NDDuring aerial applicaton work, while performing a right hand turn, the engine lost power while turning near known terrain (a butte). Aircraft lost enough power to require landing the aircraft in very rough, rock strewn terrain. Aircraft substantial damaged:…Accident 20090720012869AWSK PZLM18B · Malad City, ID(-23) N7813T was destroyed when it impacted the ground while conducting agricultural operations. The pilot was making fertilizer drops to the wheat field below. The pilot indicated encountering windshear. The pilot reported losing airspeed and altitude all at…Accident 20090720012379APiper PA22 · Fort Collins/L, CO(-23) Aircraft has conventional landing gear. Weather observation at fnl just prior to incident: "fnl 0415Z auto 33009G20KT 10 sm vcts BKN033 OVC060 21/14 A3021" pilot landed RY15,at night, with severe thunderstorm approaching from north. Lost directional…Incident 20090720011389ICessna 152 · Louisville, KY(-23) Cessna C-152, N88933 departed runway 06 at (lou) Bowman Field, Louisville, KY on 7-20-2009 at approximately 15:30 dst giving an instructional ride to a 10 year old. During the climb engine lost power and instructor pilot imediately returned to field and…Incident 20090720011029IPilats PC1245 · Mc Call, ID(-23) During taxi, left wing contacted airport vehicle, causing minor damage to outboard left wing.Accident 20090719857299ABrown Thoma Thorp T-18 · Lake Como, FLInformation is from [privacy data omitted] a passenger who was on a/c and reported accident in 10/07/2010 that happened on 07/19/2009. Was offered a ride in [privacy data omitted] a/c, N33TB, witness stated pilot attempted to land at a high rate of speed and…Accident 20090719047949ACessna 170B · Mahwah, NJOn 02/26/09 N8339A was determined to be in airworthy condition by an annual inspection. Rose ganim, PIC and owner of N8339A noted in a personal log on 06/07/09 engine rough/vibration. Aircraft was brought to same maintenance facility as annual, for inspection…Accident 20090719047909ARobinson He R44 II · West Hempfield, PADuring cruise flight pilot noted an altitude loss and determined that she was experiencing a loss of engine power. Autorotative approach to a field was executed resulting in a hard landing. Preliminary post accident examination of aircraft did not reveal a…Incident 20090719047789IPiper PA-28R-201T · Pensacola, FLPilot stated that he was cleared to land. He was second behind a Cessna with two aircraft behind him. When he was cleared to land he went through the landing checklist and stopped at the point of lowering the landing gear. He did not want to slow too much…Accident 20090719047659AO'Bert Jame VARI-EZE · Columbus, GAAircraft N39DX took off from Columbus airport (csg) and was practicing touch and go procedures. During climb from the second touch and go, the pilot reported to the tower that he had a problem. The aircraft was air-borne and approaching the end of the runway…Incident 20090719015249IBalwks FIREFLY715 · Indianola, IA(-23) Balloon gondola was located in the trailer during refueling. An unidentified source ignited one of the tanks, and the pilot stopped the fueling process but was unable to fight the fire. The fire department was contacted and the pilot contained the fire…Incident 20090719014419ICessna 182T · Dulce, NM(-23) On July 19, 2009, a Cessna 182T, N2436V, registered to the owner, made a hard landing at Jicarilla-Apache Nation airport, new Mexico while on a training flight. Visual meteorological conditions prevailed at the time and there was no flight plan filed.…Accident 20090719013309AScwzer SGS233A · Truckee, CA(-23) Student pilot on solo flight experienced a hard landing during the flare to touchdown on runway 19 at trk. Two instructors observing the landing stated that the glider appeared low and slow during the approach. They also stated that the glider landed on…Incident 20090719012979IMooney M20J · Grain Valley, MO(-23) PIC stated that he began his landing checklist while on right downwind to runway 09, and was interrupted by the radio announcement from another inbound aircraft. He determined that he could continue onto base and fina, and "just didn't put the gear…Incident 20090719011419IAmrgen AA5A · Pocaahontas, MS(-23) Aircraft departed hawkins field north to private airstrip. Reported lost of power and landed in a lake south of private airstrip near pocahontas, MS. Minor damage and no injuries.