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 20121101024919ICessna 152 · Beatrice, NEOn November 1, 2012, at 1750 pm CDT, a Cessna 152, N47586, was involved in an incident at the Beatrice municipal airport (kbie), Beatrice, Nebraska. The student pilot departed runway 36 to practice short and soft field takeoffs and landings solo in the…Incident 20121101023799IWells Elgin M Starjammer · Pensacola, FLPilot was taxiing to ramp area after performing airshow routine during practice day of airshow. Aircraft propeller struck 4 foot tall light green fire bottle at end of flight line in ramp area, damaging propeller.Incident 20121031024859IEmbraer EMB-145LR · Omaha, NEFlaps failed at zero on approach. A no flap landing executed.Incident 20121031024719IBeech F33A · Mobile, AZ[privacy data omitted] Was conducting instruction for take off and landings. [privacy data omitted] States they didn't put the landing gear down prior to landing. 44709 for the CFI will be initiated.Incident 20121031024709ICessna 210L · San Juan, PROn November 1 at 11:30 am I was directed by the front line manager to investigate an incident that took place at isla grande airport where a Cessna 210 landed with the landing gear up, on 10/31/2012 at 1840Z. This inspector and inspector manual cepeda, met…Incident 20121031024379IPiper PA-22-160 · Prescott, AZPilot[privacy data omitted] stated he was doing touch and go's in the patteren in Prescott Arizona and was on an extended down wind for runway 30 when the cockpit got a little smokey noticing he had no oil presure on the oil presiure guage. The pilot…Incident 20121031024089IBombardier CL600-2D24 · Long Beach, CAAfter pushback crew noted no starter cutout, #1 eng, then firewarning and idg high temp (which was disconnected). Both fire bottles were discharged. Ground crew noted smoke emitting from engine cowling (no visable fire) a/c towed back into gate. (Tow tractor…Accident 20121031024019APiaggio P180 · Boyne City, MIAircraft departed to the left of runway 27 and came to rest at airport boundary fence and ditch that runs parallel to the fence. Nose wheels were buried in the side of the ditch, turned to the left approximately 35 degrees from center. Tire marks in the grass…Incident 20121030024059IEclipse EA500 · Harrisburg, ILThe aircraft struck a deer upon landing on runway 6.Incident 20121029025619IRockwell International 114 · Brunswick, GAThe aircraft departed from Brunswick Golden Isles Airport, Georgia (bqk) flying to blackwell field (71J), Alabama and developed low power on climb out. The aircraft was unable to hold altitude with applied power and the pilot made an emergency landing on…Incident 20121029025529IBeech 95-B55 (T42A) · Metter, GAThe aircraft departed from hilton head, south carolina (hxd) flying to Metter Municipal Airport (mhp), after touchdown the left landing gear collapsed. Ground scars show the aircraft continued down the runway, left of the centerline, until it came to a stop…Incident 20121029025299IMaule M-7-235C · Sarasota, FLOn October 29, 2012, at approximately 10:20 eastern standard time, a registered aircraft, N1044N Maule M-7-235C, serial number 25006C was being operated by certificated pilot and during taxiing from the ramp turned onto an access road and hit a stop sign the…Incident 20121029025059IHelio H-395 · Rapid City, SDOn October 29, 2012, at appoximately 1025 MDT a Helio H-395 attempted to land at Rapid City airport in south dakota. The left wing tip and left horizontal stabilizer struck the ground. Estimated speed of the ground loop was approximately 35 mph. The pilot and…Incident 20121029024732IBeech B200C · Torrance, CAOn 10/29/2012 at 15:45 PST, pilot taxiing king air, N133US, eastbound on ramp prior to taxiway charlie "c" made contact with propeller of parked Cirrus, N321PM, with left wing tip.Accident 20121029024029ACessna 152 · Long Beach, CAOn pilots' second "solo" landing in CE-152 with CFI observing from side of runway, the CFI witnessed upon landing the aircraft bounced back into the air. The pilot appeared to lower the nose in an attempt to get the aircraft back onto the runway. The aircraft…Incident 20121028028709IWeatherly 620B · Ness City, KSWhile landing on runway 17 at Ness City Municipal (48K), the aircraft veered left off the left (east) side of the runway colasping the landing gear. The pilot reported the brakes were soft.Incident 20121028025819ICessna T210M · Asheville, NCAirman taxied from parking spot located between txwy D2 and txwy f, straight ahead (west) past yellow taxi line and into adjacent parking spot stricking one orange cone and one large chock causing damage to the propeller.Incident 20121028025039ICessna A185F · Yakutat, AKOn 10/28/12 civil aircraft N8269Q was on a part 91 ferry flight from anchorage to dallas fort worth. Upon landing in Yakutat aircraft ground looped and slid off runway, resulting damage was to the right wing tip and the right landing gear assembly.Incident 20121028025009IChester, SCThe parachutist was participating in a parachute jump with other parachutists into a drop zone. The jump commenced at approximately 6000 feet mean sea level from a Cessna 208 caravan .approximaely 20 seconds from the ground, the parachutist executed a high…Incident 20121028024879IRobinson Helicopter R22 Beta · Chesterfield, MOA student pilot, while on a solo flight, performed a forced landing northwest of ksus, at rombach's farm. The pilot confirmed that after departure and turning crosswind, he got dizzy, experienced blurred vision, and made the decision to perform an emergency…Incident 20121028024849ICessna 210C · Camden, TNOn October 28, 2012, at approx. 1400 the owner/pilot of N3668Y, a Cessna 210C, landed at Benton County Airport, 0M4, gear up. The pilot was returning from paris aviation, paris, TN, after assisting an airframe and powerplant mechanic with landing gear…Accident 20121028024629ARobinson Helicopter R22 Beta · Port Allen, HIThe student pilot initiated a solo flight at approximately 15:15 Hawaii local time and departed Port Allen Airport toward the north west. Approximately 7 to 10 minutes into the flight, the pilot felt a strong vibration in the airframe. The pilot decided to…Incident 20121028024609IPiper J3C-65 · Wichita, KSThe pilot in command was providing flight instruction to an airline transport rated pilot in a conventional gear aircraft. This flight was the first instructional flight for the student in this aircraft. The instructor and student departed the hard surface…Accident 20121028024319APiper PA-32R-300 · Sevierville, TNPilot departed gkt on IFR flight plan. Controller asked if pilot wanted to continue to volunteer VORTAC or accept radar vectors. Pilot responded he would take vectors. Controller told pilot turn to 260 degrees and climb and maintain 6000 feet. This was…Accident 20121028023729AUS Light Hornet · Baytown, TXPilot was flying approximately 50 off the ground over farm land. Eye witness stated aircraft flew right over him while he was driving his tractor in the field. The eye witness stated he watched aircraft continue to fly south through field. Pilot pulled up to…Incident 20121028023389IBeech B24R · Arlington, WAOn October 28, 2012, at aprox. 2:45 pm, aircraft N2533W, a Beech BE24, piloted by [privacy data omitted] and the only occupant,while landing at Arlington Airport, Washington, the nose gear retracted after touchdown at awo rwy 11. Pilot admitted he…Incident 20121028022949ICessna 337G · Little Rock, AROn October 28, 2012, at 2120 CDT, a Cessna 337, N53510, registered to rutledge air LLC, had the landing gear collapse on landing at adams field, Little Rock, Arkansas while on a 14CFR, part 91 flight. Visual meteorological conditions prevailed at the time and…Incident 20121027029259ICessna P210N · Oakland, CANTSB incident number: WPR13IA026 Day VFR - visibility unlimited - 600FT into landing roll out main gear collapsed, nose gear remained down and locked. Aircraft continued an additional 400 ft down the runway and came to rest on wing left tip. No pre or post…Incident 20121027027279ICessna A185F · Jackson, MIAircraft landed rwy 32 at jxn, after conducting pipeline patrol flight. ATIS (30 minutes old) reported winds as 360/8, gusting 16. Tower twice reported winds as 360/8. Aircraft ballooned in flare, touched down on centerline, then drifted to the right, with…Accident 20121027025019ABates Starduster SA-300 · Reklaw, TXAircraft was landed hard, bouncing in a t least three times. When it finally settled in it was in a depressed area of the runway surface and the propeller came in contact with the ground, digging into the dirt which caused the aircraft to ground loop. A video…Incident 20121027024459IBeech 95-B55 (T42A) · Linden, NJPilot reported a gear problem and landed with the landing gear in up position. The airplane came to rest about half way down the runway and about 10 feet left of the centerline.Accident 20121027024329ACessna 170A · Calexico, CAN1332D, a Cessna C170A lost control on landing at Calexico airport. (Runway 26) the pilot attempted a go-around but could not climb and impacted the ground a few feet to the right side of runway 26. The aircraft spun on the ground during the impact and was…Accident 20121027024039ARobinson Helicopter R22 Mariner · Lake Havasu Cit, AZCommercial pilot [privacy data omitted] was operating the Robinson R-22 helicopter, for the boatpix company, over the south lake Havasu area for the purpose of obtaining photographs of various privately owned water craft. Subsequent retail revenue would be…Accident 20121027024009AJeffair Barracuda · Payson, AZIn preparation for landing at Payson Airport, AZ (pan), pilot had an unsafe nose gear indication. He made a low approach and was advised by another pilot on The graound that The nose gear appeared down and locked. Upon landing on runway 06 The nose gear…Accident 20121027023989APorter James Grant Superior CUB · Indianapolis, INThe pilot, the lone occupant of the aircraft, started the engine of N97RP and taxied (east to west) across the vacant field adjacent to and west of [privacy data omitted] to do his preflight checks. He planned to takeoff to the north. He did his preflight…Incident 20121027023779IPiper PA-31-325 · Pensacola, FLPilot was on final approach to runway 35 configured with full flaps. As the pilot began to flare for landing, pns ATCT advised pilot to go around. Pilot applied full power. Pilot then realized gear was not down and lowered the landing gear handle. The…Incident 20121027023509ICessna 207A · Emmonak, AKDuring a landing approach to Emmonak Airport, the pilot reported the engine began to surge. The pilot applied full rich mixture and the engine quit. The aircraft landed in a grassy and brush covered area approximatley 4 miles south by soutwest of Emmonak…Incident 20121027023439IDehavilland DHC-6 Twin Otter · Wainwright, AKThe operator was conducting survey operations which require the aircraft to be flown at a specfic speed and altitude. The pilot was in the process of slowing down the aircraft by lowering the flaps and maintaining the proper altitude and air speed to perform…Incident 20121027022969IPiper PA-28-235 · Bath, MIPilot landed hard on grass strip, runway 27 at University Airpark, Bath michigin. After touch down the nose strut sunk into the wet grass breakingthe engine mount and damageing the propeller and nose strut.Incident 20121026026409IDehavilland DHC-6 Twin Otter · Eloy, AZInspectors from this office conducted an investigation of a sport parachute incident at Eloy municipal airport. On 10-26-2012, mr. ****** rented a harness and main canopy from ******, a local company that rents skydiving equipment. On his first jump of the…Incident 20121026025799IS.O.C.A.T.A. MS893E · Albuquerque, NMOn 26 October, 2012 while flying a local flight on aircraft N349RA, a socata rallye (MS893E), s/n 13178 the pilot in command (PIC) landed on runway 35 without incident. Upon turning onto intersection B1 on taxi-back the PIC felt the aircraft shake hard for a…Incident 20121026025061IPiper PA-32R-300 · Greensboro, NCPilot overnighted at Greensboro, NC Pti Airport and sustained minor rudder damage by an unknown person.Incident 20121026024659IBeech C-45H · Chattanooga, TNDescription: aircraft departed home base (1A0) for a reposition flight to Chattanooga metro airport (kcha). Upon landing on runway 20 at kcha, pilot lost longitudinal control during rollout. The left wing tip contacted the runway and upon pilot correction the…Accident 20121026023231AGrumman American Avn. AA-5A · Fairhope, ALPilot made normal approach and landing on runway 1. Approximately 200 feet into the rollout pilot reported that the aircraft began to veer to the left. Pilot applied right toe brake in an unsuccessful attempt to control direction. Aircraft struck another…Accident 20121026023221APiper PA-22 · Fairhope, ALPilot taxied out to runway 1 at taxiway A2. Pilot conducted runup and then pulled forward of the hold short line to have better visibility of final approach course. Pilot observed another aircraft on short final and continued to hold at taxiway A2. During…Accident 20121026023159ARobinson Helicopter R44 II · Toutle, WAPrivate pilot [privacy data omitted] was the sole occupant while conducting external load operations, moving christmas trees on his private property. During a post accident interview, [privacy data omitted] said that he was hovering above a load he intended…Incident 20121025028519ICessna U206G · Port Graham, AKAfter takeoff from Port Graham, pilot set aircraft to climb power. At an altitude a little above 2000 feet, pilot heard a loud ?pop? And experienced a partial loss of engine power. Pilot stated that he had sufficient altitude to return to the Port Graham…Incident 20121025026219IPiper PA-28R-200 · Albany, ORStudent and instructor were in the process of doing a touch and go. When student was cleaning up acft for take off he inadvertently selected gear handle instead on selecting flap handle. Coordinated with the NTSB with photos to classify this as an incident.…Accident 20121025025719ABeech A36 · Hooksett, NHPIC suffered a catastrpohic heart attack while inflight. Aircraft came to rest on median strip near I-93 after striking a light stantion. Aircraft destroyed, both occupants were killed.Incident 20121025024749ICessna 402C · Fort Lauderdale, FLOn October 25th about 0830 EST shortly after take-off from Fort Lauderdale intl. Airport, Cessna 402C, registration number N767PA experienced low oil pressure on the left engine. The pilot elected to return to Fort Lauderdale intl. A mechanic changed the oil…