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 20060218001539IBoeing 7272K5 · Kansas City, MO(-23) On February 18, 2006 custom air transport (cat) flight 16 was enroute from dayton, Ohio to Kansas City, Missouri. Approximately 260 miles from Kansas City International Airport (kmci) at 26000 feet cat flight 16 experienced a compressor stall in number…Incident 20060217009259IMooney M20K · Montevideo, MN(-23) Night landing, flared high, bounced, drifted off to the side of the runway, contacted snow bank.Accident 20060217007749ACessna 177 · Carefree, AZ(-23) The pilot reports that he failed to properly flightplan the aircraft fuel burn for the planned flight. The pilot recently purchased this aircraft and had little operational experience. The pilot offered no other reason for having a fuel depletion on…Incident 20060217003369ISkrsky S76C · Houma, LA(-23) On 2-17-06, at approximately 1230 local, N766P, a SK-76C+ with a crew of two and seven passengers landed on the helideck of a moving vessel and while at 100% rotor RPM rotor blade contact was made with the vessel. After landing and during passenger…Accident 20060217002839ABell 206B · Manchester, KY(-23) The helicopter was being repositioned from charleston w. VA (crw) to middlesboro KY (1A6) in order to conduct a part 135 flight. Prior to reaching 1A6 the pilot landed due to deteriorating weather (fog). After conferring with company personnel the pilot…Accident 20060217002689APiper PA30 · Greeley, CO(-23) N7743Y, made a gear up landing at gxy after a missed approach for a "no gear indication". The landing gear would not extend during the two attempts to land. When the aircraft was lifted up off the runway surface the landing gear extended and locked into…Accident 20060217002669AAmtr VANSRV4 · Wichita, KS(-23) As the aircraft was departing runway 36 at Colonel James Jabara Airport (aao), the canopy came open at approximately 50 to 100 feet alg. The pilot lost control of the aircraft while attempting to close the canopy and land on the remaining runway. The…Accident 20060216029549ACessna 150 · Husum, WA(-23) Aircraft departed Husum, Washington, from the aircraft owner's/pilot's property, became airborne then impacted the earth 200 yards from takeoff. The pilot was removed from the wreckage before I arrived at the accident site. During the investigation…Accident 20060216003849AAmtr Express · Tyler, TX(-23) On February 16, 2006 at approximately 2315 zulu a hodge Express CT, N410MP, s/n 001 crashed while attempting an approach to runway 22 at Tyler Pounds airport, Tyler, Texas. The aircraft was piloted by [privacy data omitted]. One passenger [privacy data…Accident 20060216003689ACessna 525A · Tampa, FL(-23) On February 16, 2006, at 1647 EST, a Cessna 525A, N701TF, operating on a personal flight, encountered a primary and secondary (emergency), left main landing gear, brake system failure and departed runway 18L at Tampa international airport, Florida.…Incident 20060216002969ICessna 402C · Ponce, Puerto Rico(-23) Cape air flight KAP193 (#27), departed from san juan international airport to Ponce, PR with three passengers and one pilot in command. The flight to Ponce was uneventful. Upon landing at the merceditas airport at Ponce, the nose gear collapsed by…Accident 20060216002819APiper PA28140 · Lehigh Acres, FL(-23) On February 16, 2006 a Piper PA-28-140, N14MA, registered to corporate enterprises inc. was at 2500 feet for thirty minutes when the engine lost all power for unknown reasons. The pilot attempted to make an emergency landing on an isolated road when he…Accident 20060216001989AMooney M20F · Willits, CA(-23) On 02/16/06 at approximately 19:39 PST while attempting a night landing at Willits CA airport id O28, certified flight instructor [privacy data omitted] , while providing night re-currency training to the pilot [privacy data omitted] , a certified…Accident 20060216001899ACessna 172M · Prescott, AZ(-23) Cessna 172M FAA registration number N13514 was landing on runway 12 at Ernest A Love Field (prc), Prescott, Arizona. Reported wind 130 degrees at 14 knots gusting to 19 knots. Pilot lost control of the aircraft on landing. The aircraft departed the…Accident 20060216001479ABeech 95 · Kingman, AZ(-23) On February 16, 2006 at 1800 MST student pilot missed a single engine practice vor/dme approach into runway 21 at kigm and removed his foggles that he was wearing for training. The CFI assumed command of the aircraft, and was demonstrating the first…Incident 20060215008239IPiper PA44180 · Mulino, OR(-23) The aircraft landed at Mulino, Oregon (4S9), a few seconds after touch down the nose gear collapsed. The pilot said the gear down indicator indicated down and locked. Inspection of the nose gear revealed the down lock hook was broken and the down lock…Incident 20060215005239ICessna 177RG · Cahokia, IL(-23) The mishap pilot was in the local traffic pattern preparing to land and upon extending the landing gear he failed to get a green light and had the gear warning horn sounding. He informed the tower of the problem, cycled the gear three times and was…Accident 20060215003679AHughes 269C1 · Titusville, FL(-23) During an instructional flight student pilot allowed the aircraft to develop a high sink rate and over controlled when leveling the skids for touchdown. The instructor was late with corrective action. Aircraft landed hard.Accident 20060215002829ARobsin R22BETA · El Monte, CA(-23) Accident occurred on asphalt tarmac at El Monte Airport at 1006 hrs local PST. Prior to flight, 20 gallons of fuel was uploaded. Pilot reports he was departing to lift the aircraft into a hover and it was light on the skids. As the aircraft balanced…Accident 20060215002529ABeech C90A · Tampa, FL(-23) On February 15, 2006, at 1507 EST, a Raytheon, C90B, N12LE registered to ulair aviation, LLC, landed at Tampa International Airport (tpa) and the right main landing gear collapsed on rollout. Visual meteorological conditions prevailed at the time. The…Accident 20060215002289ACessna 152 · Augusta, ME(-23) Student pilot departed klew on a solo cross country flight to krkd-kaug-klew. Pilot deviated from flight plan by first attempting a touch and go to runway 35 at kaug. Pilot did not obtain weather information AWOS or call UNICOM for an airport advisory…Incident 20060214009229IBeech 65A80 · Bemidji, MN(-23) Aircraft departed fergus falls, MN to the minneapolis, MN airport (msp). On final approach the landing gear handle was positioned to the down position for landing. Pilot observed no nose down gear light. After cycling the gear select and still not…Incident 20060214003189IRobsin R22BETA · Corona, CA(-23) Helicopter made a hard landing at kajo. While the instructor pilot was teaching the student pilot autorotations from an altitude of 100 feet, the low RPM horn went off and the aircraft descended at a high rate. The helicopter hit the landing pad hard,…Accident 20060214003169ACessna 172M · Murrieta/Temecu, CA(-23) Airman was accomplishing touch and goes, take off was normal but shortly after takeoff 50 to 100 feet AGL aircraft failed to climb, aircraft would not hold altitude or airspeed, and started losing altitude. The airman did not know what his engine RPM…Incident 20060214002599ICndair CL6002B19 · Lincoln, NE(-23) N8783E, a CL-600, being operated by pinnacle airlines as northwest airlink flight 2973, reported an unsafe gear indication on approach to Lincoln, NE. The aircraft landed safely. When the aircraft pulled into the gate the #3 hydraulic caution light came…Incident 20060213003569ITecnam P2002SIERRA · Cedartown, GA(-23) The pilot [privacy data omitted] stated: that 20 minutes into the flight he said the engine was running fine with no audible or visual signs of a problem and the engine just quit. He said at that point he tried switching tanks, but the engine would not…Incident 20060213002469IBeech A36 · Clearwater, FL(-23) On February 13, 2006 at 9:20 am EST, a Beechcraft A36, N14RF, landed on runway 34, at Clearwater airpark (clw). After landing during rollout the pilot stated he felt the nose of the aircraft dropping and the aircraft came to a stop. Inspection of the…Accident 20060213001569AAmtr Mountaingoat · Palmer, AK(-23) Pilot, with no passengers aboard, landed his "mountain goat" experimental single engine land airplane on remote gravel airstrip approximately 23 miles south of Palmer, AK. The weather was VFR with good visibilities and ceilings and no significant winds.…Accident 20060212010559AAmtr Glasairiisft · Roseville, CA(-23) Aircraft was performing aerobatic operations over a populated area below 500 feet. Pilot lost control and crashed into a residence. Pilot, passenger and one occupant of the residence were fatal.Accident 20060212006269AMrchti S20522R · Phoenix, AZ(-23) N981WA departed from runway 07L at deer valley airport (dvt) on a pleasure flight destined for sedona, AZ. At approximately 700 to 1000' AGL N981WA experienced a sudden engine failure. The engine restarted momentarily, but it failed again. The pilot…Incident 20060212005729IAirbus A340311 · New York, NY(-23) Received call at approx 11:30 pm from ifo mgmt concerning a turkish airline A-340 aircraft that skidded off rwy 31L upon landing. Contacted the com center for a briefing on the status of the aircraft. Met ops inspector at nyifo and continued to papd for…Incident 20060212004629IBoeing 757222 · Seattle, WA(-23) United airlines #949 inbound from ord, clipped the jetway at gate N6 at the Seattle-Tacoma airport as the aircraft was being parked. The aircraft, a Boeing 757, received minor damage to the left engine upper cowling, one passenger and one flight…Incident 20060212003239IBeech F33A · Redlands, CA(-23) Interview of the pilot [privacy data omitted] (PIC) was conducted on 03-03-06. The pilot [privacy data omitted] ^ stated that he was getting his aircraft ready for its annual inspection delivery flight. He fueled the aircraft and had conducted a…Accident 20060212003179APiper PA24260 · Rancho Murieta, CA(-23) Pilot reported the landing gear would not lock in the down position. The emergency gear procedures would not help. Pilot decided to land in the dirt to the side of runway 22 (riu). Aircraft struck earth berm approx. 100 yds from runway 22. Aircraft was…Accident 20060212003159ASwftms GC1A · Rancho Murieta, CA(-23) On February 12, 2006, at 1443 hours PST, a globe swift, N80715, registered to the pilot [privacy data omitted] nosed over on landing at kriu (Rancho Murieta, CA). The aircraft received substantial damage. The pilot received some head injuries, the sole…Accident 20060212002749ACessna 172N · New Hudson, MI(-23) Pilot departed Y47 runway 25 at 11:35. Pilot entered pattern for landing on runway 25. Flight in the pattern was uneventful. Landing approach was uneventful. During the last part of landing flare over runway, pilot felt that the aircraft was slightly…Accident 20060212001959ACessna 210M · Long Beach, CA(-23) Two dock workers witnessed the aircraft attempt to make an emergency landing on the pier, and pulled the pilot from the wreckage. Neither recalls hearing any engine noise. Condition of propeller indicates the engine was not developing power. Although…Accident 20060212001929ABeech C23 · San Jose, CA(-23) The Beech sundowner crash landed about 300 feet short of runway 31L after experiencing power loss as it was about to enter a right downwind leg, at about 1,200 feet AGL, to runway 31R at Reid-Hillview airport (rhv) at San Jose, CA. After the pilot…Accident 20060211030919ACessna 180J · Essex, NY(-23) The FAA was notified by an anonymous call and later by dec police on 2/13/06 of an aircraft accident at the 41NY airport that occurred on 2/11/06 at approximately 0845 local time. The aircraft was identified as N180JS a Cessna 180J. The aircraft was…Accident 20060211013592ACessna 172P · Sacramento, CA(-23) Aircraft was in runup area at Sacramento exec airport when another aircraft taxied into it, striking the vertical structure.Incident 20060211009389IMooney M20E · Marysville, OH(-23) Private pilot [privacy data omitted] conducted a personal pleasure flight from darby dan airport (6I6) to Union County Airport (mrt). Approaching Union country he descended in a right turning spiral from 4,000 feet to 2,000 feet in preparation for…Incident 20060211009149IDoug MD11 · Kuwait, KU(-23) Aircraft departed end of runway during landing at Kuwait International Airport, Kuwait city, Kuwait. Aircraft came to rest with the nose gear approximately 80 feet into an unpaved area. Flight crew reported a normal approach and landing, but stated that…Incident 20060211003979IPiper PA28R200 · Paso Robles, CA(-23) Pilot stated while on final, the aircraft attitude was flat and upon landing he felt the nosewheel contact the ground. He then stated he chose to go around and align himself properly for another landing. After the second landing he taxied to transient…Accident 20060211003489ACessna 172N · Sacramento, CA(-23) Aircraft taxied into other aircraft in the runup area prior to takeoff.Accident 20060211002989ACessna 501 · Fort Pierce, FL(-23) The aircraft landed and ran off to the right side of the runway. Aircraft landed on runway 9, runway is 6492' in length. The first discernable signs of contact on runway by the aircraft was at sign 200 A1 approximately 3500' down the runway. Tire marks…Incident 20060211002359IDoug DC982 · Memphis, TN(-23) Aircraft was marshalled into a parked fuel truck. The aircraft was repositioning. NTSB was notified and released the aircraft. There was minor damage to l-wing tip and no injuries to crew or passengers.Incident 20060211002349IMooney M20J · Russellville, AL(-23) On February 11, 2006, at 1300 CST, a Mooney M-20-J, N201VM, registered to the pilot [privacy data omitted] made a gear up landing at the russelville airport located in Russellville Alabama. The aircraft departed from fort payne Alabama (4A9) enroute to…Accident 20060211001879ACessna P210N · Sarasota-Braden, FL(-23) On February 11, 2006 at 1418 EST, N6504P, a Cessna P210N, registered to the pilot [privacy data omitted] sustained collapse of the nose landing gear on landing rollout. Visual meteorological conditions prevailed at the time and the aircraft was on VFR…Accident 20060211001679AUnivar 415C · Arlington, WA(-23) Aircraft lost oil pressure on departure, returned to the airport and struck wing on landing.Incident 20060211001359IPiper PA18105SPEC · Steamboat Spgs, CO(-23) The airplane bounced on landing at bob Adams field (sbs) runway 32 and on the second touchdown the airplane was misaligned with the runway in a counter clockwise position causing the airplane to ground loop counter clockwise down the runway. The…