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 20120506008659AEiriavion PIK 20D · Eagleville, TN5-7-2012: On scene investigation of a sailplane accident that occurred on may 6, 2012. The accident occurred at the Puckett Field glider port located in bedford county, Tennessee. The sailplane, N39RB, crashed approximately 1016 feet from the north end of the…Incident 20120506008539ILake LA-4 · Palo Alto, CAOn may 6, 2012 [privacy data omitted] was operating an LA-4, N7615L. During an approach to Palo Alto airport the aircraft developed a nose landing gear malfunction. [privacy data omitted] Requested visual confirmation of the nose landing gear status from…Incident 20120506008109INorth American T-6G · Bayou La Batre, ALOn may 6, 2012, [privacy data omitted] was flying his texan AT-6 (N1284) from his home base in magnolia springs, Alabama to roy e. ray airport (5R7) in Bayou La Batre, Alabama for a friends flyin. The flight was uneventful until the landing. Upon landing the…Incident 20120506007599IBeech A36 · Ontario, CAPilot declared emergency due to an unsafe gear indication. Aircraft landing safely. Trouble shot and found bad bulb. Removed and replaced bulb. No futher action required. Aircraft returned to serviceIncident 20120506007389IChampion 7ECA · Willow, AKThe PIC, a student pilot was practicing landings at the Willow Airport. On downwind the PIC pulled carburator heat and reduced power before turning base leg. On base leg he added a little power to adjust his glide and the engine quit. He pumped the throttle…Accident 20120506007279AMaule M-7-260 · Brigham City, UTOn landing rollout, aircraft ground looped. Damage to right aileron. Upper and lower right wing skins wrinkled; possible right wing spar damage. Right gear collapsed.Incident 20120506006959ICessna 310R · Ogden, UTPilot had done a touch and go and was coming in for another landing. On touchdown pilot realized that gear was not down. Pilot stated that he forgot to put the gear down.Accident 20120506006919ACessna 182N · Newport, VTPossible unstable approach to runway 36, high on approach (final) with full flaps. Decrease in airspeed, pilot applied power too late to recover from excessive sink rate. Impacted runway nose wheel first. Aircraft taxied to ramp with firewall, propeller, and…Incident 20120505029119ICessna 172RG · Crystal River, FLPilot was practicing precision landings with 180 degree turns. Pilot failed to lower the landing gear prior to touch down.Incident 20120505026149IPiper PA-28-140 · Lowell, INPilot decision to land downwind caused a high ground speed approach resulting in the aircraft force landing in a field to avoid obstacles. A small furrow in that field caused the aircraft nose gear to fold aft as it came to rest resulting in minimal damage to…Accident 20120505023029ACessna 172F · Cambridge, NYDuring rotation a gust of wind hit the airplane, and the pilot lost directional control. The airplane went into a corn field the nose wheel broke off and the airplane "nosed over" onto its back. Pilot stated that it all happened very quickly, and he had not…Accident 20120505012639ACubcrafters CC11-160 · Umatilla, FLPilot stated that on landing rollout the aircraft sudenly darted left off runway. Went through ditch on side of runway causing aircraft to pitch to left side causing damage to left wing,left struts, and left elevatorsimiliar event had happened at factory with…Accident 20120505008419APiper PA-28R-201T · Williston, FLDuring climb out after touch and go at approximately 400 feet AGL the engine lost power with out notice. Aircraft had been flying for .7 hours with no indication of developing problems. Pilot reported normal preflight, fuel sumps checked fine and fuel on…Incident 20120505008129IBeech B35 · Dallas, TXOn may 5, 2012 at approximatley 1120AM CST, [privacy data omitted] acting as pilot in command of N8873A , a Beechcraft bonanza, BE-35 was conducting an instructional flight at the Dallas executive airport (krbd). The morning started out to take [privacy data…Accident 20120505007969APiper PA-28RT-201T · Mariposa, CAPilot reported that on departure (runway 08, 3306 ft) that when he could not reach 70 KTS about 2/3 down the runway, he aborted the takeoff. Aircraft went of the end of the runway into a berm at approx. 5 KTS.Accident 20120505007839AEvektor-Aerotechnik Sportstar Plus · Houston, TXPilot stated he touched down harder than expected. This caused aircraft to bounce. Upon the third bounce the nose gear wheel forks bent 90 degrees upward into the engine firewall. This caused the firewall to bow inward which caused the engine mounts to be…Incident 20120505007799IPiper PA-25-235 · Houston, TXN94MC, a Piper PA-25-235 aircraft, while doing a banner tow operation in the vecinity of downtown Houston, TX, experienced a partial loss of power. The pilot stated while operating the throttle to maintain altitude the engine did not respond normally, the RPM…Accident 20120505007689ABalloon Works Firefly 7-15 · Hallsville, MOThe pilot stated that he saw the electric power pole and wires during his approach to the chosen landing site and thought he had a good angle of descent that would clear them. However, as he came within approximately 50 to 100 feet of the ground, the wind…Accident 20120505007459ACessna 195 · Overgaard, AZThe pilot lined up to take off runway 21 at Mogollon Airpark. The pilot stated he had a light quartering tailwind. The pilot had just raised the tail when the aircraft began to veer. The pilot states that at this time during the ground roll, there was not…Accident 20120505006449ACessna 177B · Honesdale, PAThe pilot was trying to land on rwy 18 with a slight tailwind. He made two attempts to land but did a go-around on each attempt. On the 3rd try, he attempted another go-around, but the aircraft pitched nose-up steeply, the left wing dropped and the aircraft…Incident 20120504019199ICanadair CL-600-2B19 · Detroit, MIAt 1422 on Friday, may 4, 2012, comair aircraft #7141 was arriving at gate B18 as flight 2875 from lex when the aircraft rolled backwards and impacted a belt loader causing damage to the left wing. The marshalling agent parked the aircraft on the CRJ200 stop…Incident 20120504012572IBoeing 767-332 · Jamaica, NYAircraft N174DZ right wingtip contacted the right stabilizer fairing of aircraft N198DN during towing operation. Both aircrafts sustained minor damage. Aircraft N198DN was parked at the gate boarding cargo and passengers. No injuries to personnel and…Incident 20120504009409IBell 206L-3 · Homer, AK5/4/2012 - During a post flight inspection the maintenance person found the tail rotor blades damaged. The proper people were notified and corrective procedures were followed. The blades were removed and sent to the oem for inspection. 5/10/2012 - the oem…Incident 20120504007619ICessna T310R · Laramie, WYOn MAY4, 2012, at 16:26 gmt, N94HC, a Cessna T310R aircraft was substantially damaged during ground operations after aircraft struck a fuel truck, one person on board, no injuries.Incident 20120504007479IMaule M-7-260C · Kimball, NEPatwas weather data for kibm reported at 1515L, winds from 200, 16 knots with gusts to 21. The pilot reported winds from 190, 18 knots with gusts to 24 at the time of take off. The aircraft departed using runway 28; shortly after rotation, the pilot reported…Accident 20120503009649AAir Tractor AT-301 · Danbury, NEWhile returning to the airport after spraying a field, the engine stopped due to fuel depletion. During the subsequent landing attempt in a field 13 miles south of mccook, NE, the aircraft sustained damage to both wings, the right landing gear and propeller.Incident 20120503009229ICirrus Design SR22T · Addison, TXOn 5/3/2012, the southwest regional operations center faxed the daily report to dallas FSDO identifying the following:on 5/3/2012 at ADS (Addison, Texas) at 1520 local, "ADS: N171TX, SR20, had a flat tire while taxiing to runway 15, blocking the taxiway…..…Accident 20120503008679ABeech S35 · Lake In The Hil, ILDuring approach at Lake In The Hills Airport (3CK), aircraft impacted the ground east south east of the approach end of runway 26.Accident 20120503008079AFurniss Douglas W Murphy Rebel · Hayden Lake, IDThe pilot and instructor departed the coeur d'alene airport (kcoe) and flew to Hayden Lake, Idaho to practice glassy water landings. Upon touchdown, the aircraft flipped and landed inverted in the water. There were no injuries. The landing gear was found in…Incident 20120503007789IJabiru USA Sport J250-SP · Hobbs, NMOn may 3, 2012 at approximately 1500 local time, the aircraft sustained substantial damage when it encountered an unexpected wind gust after landing. The right wing was lifted off the ground and the pilot was not able to lower it. The airplane veered off to…Incident 20120503006719IBeech S35The pilot stated that he was doing a local practice flight when he attempted to change the fuel selector from the right tank to the left tank. The lever only moved partially since the headset wire was wedged underneath the fuel selector lever. He attempted…Accident 20120502010059ABerry Dean Glasair I · Columbus, GAOn may 02, 2012 at 11:00AM an accident occurred at Columbus Metropolitan Airport, Columbus ga. Aircraft involved a model glasair 1 td, N540GZ s/n 208 taking off on runway 24. The pilot Mr. Vasquez stated that power was applied for take off and at…Accident 20120502009279AHughes 269C · Phoenix, AZPilot was flying aerial photo flight with photographer on board. In cruise flight, pilot felt airframe vibration and metalic "clunk" from rear of aircraft followed by a right yaw. Aircraft did not respond to left pedal inputs. Pilot reduced throttle and…Incident 20120502009209IPiper PA-34-200 · Hondo, TXOn 05/08/2012, I examined N5049T for a reported nose gear collapse during the landing roll. The nose gear down-lock link was broken, and both props made contact with the runway. The props have tip-curl on both engines consistant with high power application.…Accident 20120502009059ABell 206B · Valley Falls, KSAircraft departed lawrence, KS with one pilot and two passengers on board for the purpose of conducting pipeline patrol operations. According to the pilot's statement, approximately 45 minutes into the flight, the pilot slowed the aircraft to a hover at…Incident 20120502008489IBeech 58TC · Santa Ana, CAMay 2, 2012 the pilot arrived at sna for a routine VFR flight. He performed a full routine preflight of the aircraft according to the checklist and did not find any anomalies. After climbing into the left seat he put his toes on the toe brakes as usual and…Incident 20120502008479IFurr Lamar H Glasair 1-FT · Monticello, GAThe pilot left covington airport on 05/02/2012 at approximately 1100 hours local time flying east and then south over lake jackson. 30 minutes into the flight all engine temperatures and pressures where normal. While over lake jackson, the engine quit running…Accident 20120502007119AShort Bros. & Harland SC7 Series 3 · Chefornak, AKThe pilot was attempting to land on runway 34 with 3 miles visibility in haze. This created a flat light situation. As the pilot lined up on final he thought the road next to the runway was actually the runway. After landing on the road he hit a large dip…Accident 20120502006739ARobinson Helicopter R22 Beta · Kona, HIOn may 2, 2012, about 1510 Hawaii standard time, N209KR, a Robinson R22 beta helicopter on an instructional flight was substantially damaged during a hard landing following a reported partial loss of engine power, near Kona, Hawaii. Visual meteorological…Incident 20120502006669IKelly Vogel KEDAN1 · Camarillo, CAOn 05/02/2012, N100DK, an experimental aircraft, was on its initial test flight from Camarillo Airport, Camarillo, CA. Upon returning to the airport, N100DK experienced a hung left main gear during extension. N100DK performed a gear up landing resulting in…Accident 20120501009919ACessna 152 · San Antonio, TXPilot flaired high and failed to go round or soften the touchdown.Incident 20120501009479IBell Helicopter Textron Canada 407 · Beluga, AKDuring a landing into a confined area, while under power the aircraft settled in the snow to a point where the rotor blades came in contact with the tops of spruce trees. All 4 rotor blades were damaged on the bottom of the blades. The leading edges and tops…Incident 20120501007149IProtzman James C PA-18 · Anchorage, AKPilot was practicing his short field takeoff and landing procedures. He stated that during his short field landing, his brakes were engaged due to being over pressurized which in turn rotated the aircraft onto its nose. Propeller struck the ground and…Accident 20120501006879ACampbell David Legacy · Durango, COWhen coming in for a landing, pilot stated he rounded out high and dropped it on to the runway (5-10 feet). Aircraft tail broke apart in 3 places aft of aft cabin bulkhead.Accident 20120501006869ACessna T210L · Elberta, UTPilots were practicing maneuvers and power off stalls. On the 4th stall the pilot in the left seat went to recover and lost power. The flight instructor took over the controls and tried to regain power but was unable. Aircraft made a forced landing in a…Accident 20120501006829ACessna 172M · Three Rivers, MIDuring part 61 flight instruction, aircraft struck deer on runway during rotation after touch and go from khai. After assessing damage & controllability of aircraft, pilot elected to continue flight to kazo, where emergency services were available due to…Incident 20120430008139IPiper PA-22-160 · Sarasota, FLOn April 30, 2012 at approximately 11:15 eastern standard time, a registered aircraft, N8587D Piper PA-22-160, serial number 22-5766, landed at Sarasota / Bradenton international airport (srq). The certificated pilot and two passengers were uninjured. The…Incident 20120430008089IMooney M20E · Auburn, ALThe pilot stated he completed his before landing checklist and proceeded with the approach. He moved the "johnson bar" forward, and locked it in place, and the single green indication light was illuminated and landed softly on runway 36 on the main gear with…Incident 20120430007069IPiper PA-28-151 · Brookings, SDOn his first cross country solo flight from mitchell, SD to Brookings, SD the student pilot (certificate no. GX-416667) was unable to maintain control of the aircraft on landing (bkx) and rolled off the left hand side of the runway, struck a sign with the…Accident 20120430006749AShoup Ronald R RV-6A · Milton, FLAircraft had departed on runway 18 at (16FL) and had gained approximately 50 feet altitude AGL when the engine started losing power and black smoke appeared from the aircraft's exhaust. The pilot turned the aircraft back toward (16FL) and attempted to land on…